I installed crankshaft but some functions don't appear in sql database

[alper-1905]

Hi everyone I can install crankshaft from Dockerfile for Ubuntu 16.04. But some cdb functions don't appear in sql database. Invisible cdb functions are shown below: -CDB_AREASOFINTERESTLOCAL() -CDB_AREASOFINTERESTGLOBAL() -CDB_AREASOFINTERESTLOCALRATE() -CDB_AREASOFINTERESTGLOBALRATE() -CDB_GETSPATIALHOTSPOTS() -CDB_GETSPATIALCOLDSPOTS() -CDB_GETSPATIALOUTLIERS -CDB_GETSPATIALHOTSPOTSRATE ...... No functions like this How can I add these fuctions on crankshaft sql database?

Please Help me!! Thank you :))

[andy-esch]

Have you checked the cdb_crankshaft schema like the examples show? https://github.com/CartoDB/crankshaft/blob/develop/doc/02_moran.md

SELECT
  c.the_geom,
  m.quads,
  m.significance,
  c.num_cyclists_per_total_population
FROM
  cdb_crankshaft.CDB_MoransILocal(
    'SELECT * FROM commute_data',
    'num_cyclists_per_total_population') As m
JOIN commute_data As c
ON c.cartodb_id = m.rowid;```

[alper-1905]

I can't see the functions that are in 10_moran.sql file from pgadmin3. How can I fix it? Thank you.

[alper-1905]

I found my fault. I installed the 0.0.1 version of crankshaft. How can I update crankshaft versions?