Exception occurred: org.apache.calcite.runtime.CalciteContextException: Column 'rowid' not found in table tablename'


#1

How to truobleshoot this error?

what are the lines and columns the error is reporting?

Error: Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 3, column 181 to line 3, column 187: Column 'rowid' not found in table 'tablename'

Of course I don’t have a ‘rowid’ column name in my table or in the view I am reading from.

Having this error trying to create a choropleth in Immerse: here an example of data I am selecting for X (val1) and Y (val2):

val1	val2
6.4	0.451441
34	3.185063
19	0.470931
13.68	0.533281
31.2	1.164433
7.12	0.378844
35.8	0.472981
16.269	0.492029
3.78	0.416461
10.203	0.637208
5.44	0.369354

#2

Hi,

Would you be able to share the definition of your table and your view.

rowid is a system generated column.

The MapD core log mapd_server.INFO will contain the full failed SQL if you could also share that log it would help resolve the issue.

regards


#3

If I’m running MapD on pre-built AWS server and also running into this issue, how could I share the log that would help assess bug?


#4

Hi,

I believe you should find mapd_server.INFO file in /raidStorage/prod/mapd-storage/data/mapd_log

This is normally the most useful log file for issue investigation

Regards


#5

Okay I’ve downloaded mapd_server.INFO

Here is some of it, pasted for simplicity:

> Log file created at: 2017/09/18 17:10:19

Running on machine: ip-172-31-34-162
Log line format: [IWEF]mmdd hh:mm:ss.uuuuuu threadid file:line] msg
I0918 17:10:19.114189 2384 MapDServer.cpp:602] MapD started with data directory at '/raidStorage/prod/mapd-storage/data’
I0918 17:10:19.114599 2384 MapDServer.cpp:609] Watchdog is set to 1
I0918 17:10:19.114606 2384 MapDServer.cpp:631] cuda block size 0
I0918 17:10:19.114610 2384 MapDServer.cpp:632] cuda grid size 0
I0918 17:10:19.114614 2384 MapDServer.cpp:633] calcite JVM max memory 1024
I0918 17:10:19.114616 2384 MapDServer.cpp:634] MapD Server Port 9091
I0918 17:10:19.114620 2384 MapDServer.cpp:635] MapD Calcite Port 9093
I0918 17:10:19.114639 2384 MapDHandler.cpp:150] MapD Server 3.2.2-20170909-373c12a
I0918 17:10:19.437615 2384 CudaMgr.cpp:127] Using 1 Gpus.
I0918 17:10:19.437798 2384 DataMgr.cpp:120] cpuSlabSize is 4096M
I0918 17:10:19.437826 2384 DataMgr.cpp:122] reserved GPU memory is 2035.35M includes render buffer allocation
I0918 17:10:19.437837 2384 DataMgr.cpp:132] gpuSlabSize is 2048M
I0918 17:10:19.437898 2384 FileMgr.cpp:116] Read table metadata, Epoch is 1 for table data at '/raidStorage/prod/mapd-storage/data/mapd_data/table_0_0/'
I0918 17:10:19.437978 2384 Calcite.cpp:156] Creating Calcite Handler, Calcite Port is 9093 base data dir is /raidStorage/prod/mapd-storage/data
I0918 17:10:19.437985 2384 Calcite.cpp:95] Running calcite server as a daemon
I0918 17:10:22.256681 2384 Calcite.cpp:124] Calcite server start took 2700 ms
I0918 17:10:22.256728 2384 Calcite.cpp:125] ping took 99 ms
I0918 17:10:22.263594 2384 Calcite.cpp:281] [{“name”:“Tan”,“ret”:“double”,“args”:[“double”]},{“name”:“Truncate__”,“ret”:“float”,“args”:[“float”,“i32”]},{“name”:“ln”,“ret”:“double”,“args”:[“double”]},{“name”:“Floor__2”,“ret”:“i32”,“args”:[“i32”]},{“name”:“Floor__3”,“ret”:“i64”,“args”:[“i64”]},{“name”:“rect_pixel_bin”,“ret”:“float”,“args”:[“float”,“float”,“float”,“i32”,“i32”]},{“name”:“Floor__1”,“ret”:“i16”,“args”:[“i16”]},{“name”:“degrees”,“ret”:“double”,“args”:[“double”]},{“name”:“approx_distance_in_meters”,“ret”:“double”,“args”:[“float”,“float”,“float”,“float”]},{“name”:“Ceil__2”,“ret”:“i32”,“args”:[“i32”]},{“name”:“Ceil__1”,“ret”:“i16”,“args”:[“i16”]},{“name”:“Ceil__3”,“ret”:“i64”,“args”:[“i64”]},{“name”:“Log10”,“ret”:“double”,“args”:[“double”]},{“name”:“Log”,“ret”:“double”,“args”:[“double”]},{“name”:“distance_in_meters”,“ret”:“double”,“args”:[“double”,“double”,“double”,“double”]},{“name”:“round_to_digit”,“ret”:“double”,“args”:[“double”,“i32”]},{“name”:“Atan2”,“ret”:“double”,“args”:[“double”,“double”]},{“name”:“Acos”,“ret”:“double”,“args”:[“double”]},{“name”:“Sin”,“ret”:“double”,“args”:[“double”]},{“name”:“Ceil”,“ret”:“double”,“args”:[“double”]},{“name”:“distance_in_meters__”,“ret”:“double”,“args”:[“float”,“float”,“float”,“float”]},{“name”:“Floor__”,“ret”:“float”,“args”:[“float”]},{“name”:“Truncate”,“ret”:“double”,“args”:[“double”,“i32”]},{“name”:“radians”,“ret”:“double”,“args”:[“double”]},{“name”:“Ceil__”,“ret”:“float”,“args”:[“float”]},{“name”:“ln__”,“ret”:“double”,“args”:[“float”]},{“name”:“reg_hex_vert_pixel_bin_y”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“i32”,“i32”]},{“name”:“reg_hex_vert_pixel_bin_x”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“i32”,“i32”]},{“name”:“Round”,“ret”:“double”,“args”:[“double”]},{“name”:“power”,“ret”:“double”,“args”:[“double”,“double”]},{“name”:“conv_4326_900913_x”,“ret”:“double”,“args”:[“double”]},{“name”:“reg_hex_horiz_pixel_bin_y”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“i32”,“i32”]},{“name”:“conv_4326_900913_y”,“ret”:“double”,“args”:[“double”]},{“name”:“Atan”,“ret”:“double”,“args”:[“double”]},{“name”:“reg_hex_horiz_pixel_bin_x”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“i32”,“i32”]},{“name”:“Floor”,“ret”:“double”,“args”:[“double”]},{“name”:“Truncate__1”,“ret”:“i16”,“args”:[“i16”,“i32”]},{“name”:“Truncate__2”,“ret”:“i32”,“args”:[“i32”,“i32”]},{“name”:“Truncate__3”,“ret”:“i64”,“args”:[“i64”,“i32”]},{“name”:“Cos”,“ret”:“double”,“args”:[“double”]},{“name”:“Log__”,“ret”:“double”,“args”:[“float”]},{“name”:“Log10__”,“ret”:“double”,“args”:[“float”]},{“name”:“Asin”,“ret”:“double”,“args”:[“double”]},{“name”:“Cot”,“ret”:“double”,“args”:[“double”]},{“name”:“Tan__”,“ret”:“double”,“args”:[“float”]},{“name”:“rect_pixel_bin_x”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“i32”]},{“name”:“rect_pixel_bin_y”,“ret”:“float”,“args”:[“float”,“float”,“float”,“float”,“float”,“i32”]},{“name”:“pi”,“ret”:“double”,“args”:[]},{“name”:“Exp”,“ret”:“double”,“args”:[“double”]}]
I0918 17:10:22.263911 2384 MapDHandler.cpp:195] Started in GPU mode
I0918 17:10:22.276856 2384 EglGLWindow.cpp:107] Window Setting: DRAWABLE_TYPE: PBUFFER.
I0918 17:10:22.276918 2384 EglUtils.cpp:61] EGL Setting: BITS_RGBA = 8.
I0918 17:10:22.276978 2384 EglUtils.cpp:84] EGL Setting: BITS_ALPHA = 8.
I0918 17:10:24.008364 2384 EglGLRenderer.cpp:101] Renderer Setting: USE_CORE_PROFILE: True.
I0918 17:10:24.043421 2384 EglGLRenderer.cpp:170] Renderer Setting: <OPENGL_MAJOR>.<OPENGL_MINOR>: 4.5.
I0918 17:10:26.307299 2384 QueryRenderManager.cpp:306] QueryRenderManager initialized for rendering. start GPU: 0, num GPUs: 1, Render cache limit: 500
I0918 17:10:28.962195 2458 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 17:10:28.962641 2458 MapDHandler.cpp:543] sql_execute :kUiMe9cNJ2s9fZgCrstuPWRwYHhf5Ihp:query_str:ALTER USER mapd (password = ‘i-******’);
I0918 17:10:28.962705 2458 MapDHandler.cpp:2819] passing query to legacy processor
I0918 17:10:28.985643 2458 MapDHandler.cpp:555] sql_execute-COMPLETED Total: 22 (ms), Execution: 12 (ms)
I0918 17:10:28.985853 2458 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 17:51:27.573357 2451 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 17:51:48.024618 2451 FileMgr.cpp:116] Read table metadata, Epoch is 1 for table data at '/raidStorage/prod/mapd-storage/data/mapd_data/table_1_1/'
I0918 18:16:59.748334 2451 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 18:17:47.127168 2452 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 18:18:41.859726 2452 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 18:19:39.619490 2453 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 18:19:49.438814 2453 MapDHandler.cpp:543] sql_execute :xk4nxRD6WTU9Ph94s3Fimuuh3Sij4pja:query_str:ls ;
I0918 18:19:49.439196 2453 Calcite.cpp:247] User mapd catalog mapd sql 'ls ;'
E0918 18:19:50.243206 2453 MapDHandler.cpp:2823] Exception: Parse failed: Non-query expression encountered in illegal context
I0918 18:19:53.798662 2453 MapDHandler.cpp:543] sql_execute :xk4nxRD6WTU9Ph94s3Fimuuh3Sij4pja:query_str:ls;
I0918 18:19:53.799002 2453 Calcite.cpp:247] User mapd catalog mapd sql 'ls;'
E0918 18:19:53.807318 2453 MapDHandler.cpp:2823] Exception: Parse failed: Non-query expression encountered in illegal context
I0918 18:19:56.270197 2453 MapDHandler.cpp:543] sql_execute :xk4nxRD6WTU9Ph94s3Fimuuh3Sij4pja:query_str:ls ;
I0918 18:19:56.270601 2453 Calcite.cpp:247] User mapd catalog mapd sql 'ls ;'
E0918 18:19:56.277370 2453 MapDHandler.cpp:2823] Exception: Parse failed: Non-query expression encountered in illegal context
I0918 19:08:12.466658 2454 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 19:08:12.536077 2454 MapDHandler.cpp:543] sql_execute :qD5hKwjKneC75vJE1SSmzW1o8FwPSMuV:query_str:SELECT * FROM gobbledeedook LIMIT 1 ;
I0918 19:08:12.536590 2454 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM gobbledeedook LIMIT 1 ;'
E0918 19:08:12.619493 2454 MapDHandler.cpp:2823] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 20: Object ‘gobbledeedook’ not found
I0918 19:08:12.694181 2454 MapDHandler.cpp:543] sql_execute :qD5hKwjKneC75vJE1SSmzW1o8FwPSMuV:query_str:CREATE TABLE gobbledeedook (“id” TEXT , “address” TEXT , “createdTime” TIMESTAMP NOT NULL, “chainId” TEXT , “contactUrl” TEXT , “description” TEXT , “keyword” TEXT , “modifiedTime” TIMESTAMP NOT NULL, “name” TEXT , “postcode” TEXT , “seasonality” INTEGER , “slug” TEXT , “spaceId” TEXT , “venueIdOfPreviousOccupant” TEXT , “website” TEXT , “latitude” DOUBLE PRECISION , “longitude” DOUBLE PRECISION , “numMedia” INTEGER , “numNewsletters” INTEGER , “hasFacebook” BIT(1) , “hasInsta” BIT(1) , “placeTypeName” TEXT , “statusTypeName” TEXT , “primtid” TEXT , “menuCheckTime” TIMESTAMP , “jumpNote” TEXT , “inGeneric” BIT(1) , “setupTime” TIMESTAMP , “jumpedTime” TIMESTAMP , “spoonedTime” TIMESTAMP , “verifiedTime” TIMESTAMP , “offeringsValue” INTEGER , “TagName” TEXT , “offeringTag” TEXT , “boundaryName” TEXT NOT NULL, “boundaryType” INTEGER , “boundaryAdminLevel” INTEGER ) ;
I0918 19:08:12.694305 2454 MapDHandler.cpp:2819] passing query to legacy processor
E0918 19:08:12.703325 2454 MapDHandler.cpp:2839] Syntax error at: "
I0918 19:08:12.772737 2454 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 19:25:57.172417 2456 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 19:25:57.241387 2456 MapDHandler.cpp:543] sql_execute :77vF7cYjRNHFeQY5IFLnEvSNDxxWZItk:query_str:SELECT * FROM gobbledeedook LIMIT 1 ;
I0918 19:25:57.241755 2456 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM gobbledeedook LIMIT 1 ;'
E0918 19:25:57.254770 2456 MapDHandler.cpp:2823] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 20: Object ‘gobbledeedook’ not found
I0918 19:25:57.324184 2456 MapDHandler.cpp:543] sql_execute :77vF7cYjRNHFeQY5IFLnEvSNDxxWZItk:query_str:CREATE TABLE gobbledeedook (“id” TEXT , “address” TEXT , “createdTime” TIMESTAMP NOT NULL, “chainId” TEXT , “contactUrl” TEXT , “description” TEXT , “keyword” TEXT , “modifiedTime” TIMESTAMP NOT NULL, “name” TEXT , “postcode” TEXT , “seasonality” INTEGER , “slug” TEXT , “spaceId” TEXT , “venueIdOfPreviousOccupant” TEXT , “website” TEXT , “latitude” DOUBLE PRECISION , “longitude” DOUBLE PRECISION , “numMedia” INTEGER , “numNewsletters” INTEGER , “hasFacebook” BIT(1) , “hasInsta” BIT(1) , “placeTypeName” TEXT , “statusTypeName” TEXT , “primtid” TEXT , “menuCheckTime” TIMESTAMP , “jumpNote” TEXT , “inGeneric” BIT(1) , “setupTime” TIMESTAMP , “jumpedTime” TIMESTAMP , “spoonedTime” TIMESTAMP , “verifiedTime” TIMESTAMP , “offeringsValue” INTEGER , “TagName” TEXT , “offeringTag” TEXT , “boundaryName” TEXT NOT NULL, “boundaryType” INTEGER , “boundaryAdminLevel” INTEGER ) ;
I0918 19:25:57.324306 2456 MapDHandler.cpp:2819] passing query to legacy processor
E0918 19:25:57.333423 2456 MapDHandler.cpp:2839] Syntax error at: "
I0918 19:25:57.402259 2456 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 19:33:35.034919 2457 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 19:33:35.132581 2457 MapDHandler.cpp:543] sql_execute :ZNlDqIhpVM6TLjE5QXOI8vHNzgscm6pP:query_str:SELECT * FROM gobbledeedook LIMIT 1 ;
I0918 19:33:35.132975 2457 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM gobbledeedook LIMIT 1 ;'
E0918 19:33:35.142740 2457 MapDHandler.cpp:2823] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 20: Object ‘gobbledeedook’ not found
I0918 19:33:35.223238 2457 MapDHandler.cpp:543] sql_execute :ZNlDqIhpVM6TLjE5QXOI8vHNzgscm6pP:query_str:CREATE TABLE gobbledeedook ( id TEXT , address TEXT , createdTime TIMESTAMP NOT NULL, chainId TEXT , contactUrl TEXT , description TEXT , keyword TEXT , modifiedTime TIMESTAMP NOT NULL, name TEXT , postcode TEXT , seasonality INTEGER , slug TEXT , spaceId TEXT , venueIdOfPreviousOccupant TEXT , website TEXT , latitude DOUBLE PRECISION , longitude DOUBLE PRECISION , numMedia INTEGER , numNewsletters INTEGER , hasFacebook BIT(1) , hasInsta BIT(1) , placeTypeName TEXT , statusTypeName TEXT , primtid TEXT , menuCheckTime TIMESTAMP , jumpNote TEXT , inGeneric BIT(1) , setupTime TIMESTAMP , jumpedTime TIMESTAMP , spoonedTime TIMESTAMP , verifiedTime TIMESTAMP , offeringsValue INTEGER , TagName TEXT , offeringTag TEXT , boundaryName TEXT NOT NULL, boundaryType INTEGER , boundaryAdminLevel INTEGER ) ;
I0918 19:33:35.223340 2457 MapDHandler.cpp:2819] passing query to legacy processor
E0918 19:33:35.232717 2457 MapDHandler.cpp:2839] Syntax error at: BIT
I0918 19:33:35.306511 2457 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 19:43:12.045081 2458 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 19:43:12.114666 2458 MapDHandler.cpp:543] sql_execute :ZOKS66JwKfjUKCIEIfdUR2bv7pPyuq6d:query_str:SELECT * FROM venues LIMIT 1 ;
I0918 19:43:12.115205 2458 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM venues LIMIT 1 ;'
E0918 19:43:12.123354 2458 MapDHandler.cpp:2823] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 13: Object ‘venues’ not found
I0918 19:43:12.193336 2458 MapDHandler.cpp:543] sql_execute :ZOKS66JwKfjUKCIEIfdUR2bv7pPyuq6d:query_str:CREATE TABLE venues ( id TEXT , address TEXT , createdTime TIMESTAMP NOT NULL, chainId TEXT , contactUrl TEXT , description TEXT , keyword TEXT , modifiedTime TIMESTAMP NOT NULL, name TEXT , postcode TEXT , seasonality INTEGER , slug TEXT , spaceId TEXT , venueIdOfPreviousOccupant TEXT , website TEXT , latitude DOUBLE PRECISION , longitude DOUBLE PRECISION , numMedia INTEGER , numNewsletters INTEGER , hasFacebook BIT(1) , hasInsta BIT(1) , placeTypeName TEXT , statusTypeName TEXT , primtid TEXT , menuCheckTime TIMESTAMP , jumpNote TEXT , inGeneric BIT(1) , setupTime TIMESTAMP , jumpedTime TIMESTAMP , spoonedTime TIMESTAMP , verifiedTime TIMESTAMP , offeringsValue INTEGER , TagName TEXT , offeringTag TEXT , boundaryName TEXT NOT NULL, boundaryType INTEGER , boundaryAdminLevel INTEGER ) ;
I0918 19:43:12.193392 2458 MapDHandler.cpp:2819] passing query to legacy processor
E0918 19:43:12.202579 2458 MapDHandler.cpp:2839] Syntax error at: BIT
I0918 19:43:12.272058 2458 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 19:45:11.331745 2451 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 19:45:11.400038 2451 MapDHandler.cpp:543] sql_execute :P9wQjoKRinYcuUjsFjb3Fesr1IG0d16i:query_str:SELECT * FROM venues LIMIT 1 ;
I0918 19:45:11.400538 2451 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM venues LIMIT 1 ;'
E0918 19:45:11.408644 2451 MapDHandler.cpp:2823] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 13: Object ‘venues’ not found
I0918 19:45:11.477423 2451 MapDHandler.cpp:543] sql_execute :P9wQjoKRinYcuUjsFjb3Fesr1IG0d16i:query_str:CREATE TABLE venues ( id TEXT , address TEXT , createdTime TIMESTAMP NOT NULL, chainId TEXT , contactUrl TEXT , description TEXT , keyword TEXT , modifiedTime TIMESTAMP NOT NULL, name TEXT , postcode TEXT , seasonality INTEGER , slug TEXT , spaceId TEXT , venueIdOfPreviousOccupant TEXT , website TEXT , latitude DOUBLE PRECISION , longitude DOUBLE PRECISION , numMedia INTEGER , numNewsletters INTEGER , hasFacebook BIT(1) , hasInsta BIT(1) , placeTypeName TEXT , statusTypeName TEXT , primtid TEXT , menuCheckTime TIMESTAMP , jumpNote TEXT , inGeneric BIT(1) , setupTime TIMESTAMP , jumpedTime TIMESTAMP , spoonedTime TIMESTAMP , verifiedTime TIMESTAMP , offeringsValue INTEGER , TagName TEXT , offeringTag TEXT , boundaryName TEXT NOT NULL, boundaryType INTEGER , boundaryAdminLevel INTEGER ) ;
I0918 19:45:11.477496 2451 MapDHandler.cpp:2819] passing query to legacy processor
E0918 19:45:11.486472 2451 MapDHandler.cpp:2839] Syntax error at: BIT
I0918 19:45:11.555294 2451 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 19:53:35.518162 2452 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 19:53:35.585265 2452 MapDHandler.cpp:543] sql_execute :cHD0xjXhb3d6qS23z8WwnM36PwE4qFH3:query_str:SELECT * FROM venues LIMIT 1 ;
I0918 19:53:35.585795 2452 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM venues LIMIT 1 ;'
E0918 19:53:35.595914 2452 MapDHandler.cpp:2823] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 13: Object ‘venues’ not found
I0918 19:53:35.663434 2452 MapDHandler.cpp:543] sql_execute :cHD0xjXhb3d6qS23z8WwnM36PwE4qFH3:query_str:CREATE TABLE venues ( id TEXT , address TEXT , createdTime TIMESTAMP NOT NULL, chainId TEXT , contactUrl TEXT , description TEXT , keyword TEXT , modifiedTime TIMESTAMP NOT NULL, name TEXT , postcode TEXT , seasonality INTEGER , slug TEXT , spaceId TEXT , venueIdOfPreviousOccupant TEXT , website TEXT , latitude DOUBLE PRECISION , longitude DOUBLE PRECISION , numMedia INTEGER , numNewsletters INTEGER , hasFacebook BIT(1) , hasInsta BIT(1) , placeTypeName TEXT , statusTypeName TEXT , primtid TEXT , menuCheckTime TIMESTAMP , jumpNote TEXT , inGeneric BIT(1) , setupTime TIMESTAMP , jumpedTime TIMESTAMP , spoonedTime TIMESTAMP , verifiedTime TIMESTAMP , offeringsValue INTEGER , TagName TEXT , offeringTag TEXT , boundaryName TEXT NOT NULL, boundaryType INTEGER , boundaryAdminLevel INTEGER ) ;


#6

I0918 19:53:35.663580 2452 MapDHandler.cpp:2819] passing query to legacy processor
E0918 19:53:35.672612 2452 MapDHandler.cpp:2839] Syntax error at: BIT
I0918 19:53:35.739696 2452 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 19:55:22.340651 2454 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 19:55:39.181813 2454 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 19:59:58.943131 2456 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 19:59:59.011245 2456 MapDHandler.cpp:543] sql_execute :Fq5Eaok0Wseneqbi3OSuC3eZRJlU3EKf:query_str:SELECT * FROM venues LIMIT 1 ;
I0918 19:59:59.011674 2456 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM venues LIMIT 1 ;'
E0918 19:59:59.019788 2456 MapDHandler.cpp:2823] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 13: Object ‘venues’ not found
I0918 19:59:59.088655 2456 MapDHandler.cpp:543] sql_execute :Fq5Eaok0Wseneqbi3OSuC3eZRJlU3EKf:query_str:CREATE TABLE venues ( id TEXT , address TEXT , createdTime TIMESTAMP NOT NULL, chainId TEXT , contactUrl TEXT , description TEXT , keyword TEXT , modifiedTime TIMESTAMP NOT NULL, name TEXT , postcode TEXT , seasonality INTEGER , slug TEXT , spaceId TEXT , venueIdOfPreviousOccupant TEXT , website TEXT , latitude DOUBLE PRECISION , longitude DOUBLE PRECISION , numMedia INTEGER , numNewsletters INTEGER , hasFacebook BIT(1) , hasInsta BIT(1) , placeTypeName TEXT , statusTypeName TEXT , primtid TEXT , menuCheckTime TIMESTAMP , jumpNote TEXT , inGeneric BIT(1) , setupTime TIMESTAMP , jumpedTime TIMESTAMP , spoonedTime TIMESTAMP , verifiedTime TIMESTAMP , offeringsValue INTEGER , TagName TEXT , offeringTag TEXT , boundaryName TEXT NOT NULL, boundaryType INTEGER , boundaryAdminLevel INTEGER ) ;
I0918 19:59:59.088731 2456 MapDHandler.cpp:2819] passing query to legacy processor
E0918 19:59:59.097725 2456 MapDHandler.cpp:2839] Syntax error at: BIT
I0918 19:59:59.165974 2456 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 20:27:44.391362 2457 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 20:27:44.484582 2457 MapDHandler.cpp:543] sql_execute :ZmRRcfuYG0NdU8eUxxQ0ScLPOJCyR9S0:query_str:SELECT * FROM venues LIMIT 1 ;
I0918 20:27:44.484907 2457 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM venues LIMIT 1 ;'
E0918 20:27:44.495198 2457 MapDHandler.cpp:2823] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 13: Object ‘venues’ not found
I0918 20:27:44.574961 2457 MapDHandler.cpp:543] sql_execute :ZmRRcfuYG0NdU8eUxxQ0ScLPOJCyR9S0:query_str:CREATE TABLE venues ( id TEXT , address TEXT , createdTime TIMESTAMP NOT NULL, chainId TEXT , contactUrl TEXT , description TEXT , keyword TEXT , modifiedTime TIMESTAMP NOT NULL, name TEXT , postcode TEXT , seasonality INTEGER , slug TEXT , spaceId TEXT , venueIdOfPreviousOccupant TEXT , website TEXT , latitude DOUBLE PRECISION , longitude DOUBLE PRECISION , numMedia INTEGER , numNewsletters INTEGER , hasFacebook BIT(1) , hasInsta BIT(1) , placeTypeName TEXT , statusTypeName TEXT , primtid TEXT , menuCheckTime TIMESTAMP , jumpNote TEXT , inGeneric BIT(1) , setupTime TIMESTAMP , jumpedTime TIMESTAMP , spoonedTime TIMESTAMP , verifiedTime TIMESTAMP , offeringsValue INTEGER , TagName TEXT , offeringTag TEXT , boundaryName TEXT NOT NULL, boundaryType INTEGER , boundaryAdminLevel INTEGER ) ;
I0918 20:27:44.575080 2457 MapDHandler.cpp:2819] passing query to legacy processor
E0918 20:27:44.584094 2457 MapDHandler.cpp:2839] Syntax error at: BIT
I0918 20:27:44.657785 2457 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 20:45:33.740599 2458 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 20:45:33.808732 2458 MapDHandler.cpp:543] sql_execute :8asI4M9aHEDg6xuCLsFZFba3ItuthKGQ:query_str:SELECT * FROM venues LIMIT 1 ;
I0918 20:45:33.809262 2458 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM venues LIMIT 1 ;'
E0918 20:45:33.818251 2458 MapDHandler.cpp:2823] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 13: Object ‘venues’ not found
I0918 20:45:33.886689 2458 MapDHandler.cpp:543] sql_execute :8asI4M9aHEDg6xuCLsFZFba3ItuthKGQ:query_str:CREATE TABLE venues ( id TEXT , address TEXT , createdTime TIMESTAMP NOT NULL, chainId TEXT , contactUrl TEXT , description TEXT , keyword TEXT , modifiedTime TIMESTAMP NOT NULL, name TEXT , postcode TEXT , seasonality INTEGER , slug TEXT , spaceId TEXT , venueIdOfPreviousOccupant TEXT , website TEXT , latitude DOUBLE PRECISION , longitude DOUBLE PRECISION , numMedia INTEGER , numNewsletters INTEGER , hasFacebook BIT(1) , hasInsta BIT(1) , placeTypeName TEXT , statusTypeName TEXT , primtid TEXT , menuCheckTime TIMESTAMP , jumpNote TEXT , inGeneric BIT(1) , setupTime TIMESTAMP , jumpedTime TIMESTAMP , spoonedTime TIMESTAMP , verifiedTime TIMESTAMP , offeringsValue INTEGER , TagName TEXT , offeringTag TEXT , boundaryName TEXT NOT NULL, boundaryType INTEGER , boundaryAdminLevel INTEGER ) ;
I0918 20:45:33.886741 2458 MapDHandler.cpp:2819] passing query to legacy processor
E0918 20:45:33.895766 2458 MapDHandler.cpp:2839] Syntax error at: BIT
I0918 20:45:33.963768 2458 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 20:49:04.748085 2451 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 20:49:04.816426 2451 MapDHandler.cpp:543] sql_execute :gZW7v5VSvuZaDXrw7bkCogTYktaNjy5N:query_str:SELECT * FROM venues LIMIT 1 ;
I0918 20:49:04.816753 2451 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM venues LIMIT 1 ;'
E0918 20:49:04.824559 2451 MapDHandler.cpp:2823] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 13: Object ‘venues’ not found
I0918 20:49:04.893241 2451 MapDHandler.cpp:543] sql_execute :gZW7v5VSvuZaDXrw7bkCogTYktaNjy5N:query_str:CREATE TABLE venues ( id TEXT , address TEXT , createdTime TIMESTAMP NOT NULL, chainId TEXT , contactUrl TEXT , description TEXT , keyword TEXT , modifiedTime TIMESTAMP NOT NULL, name TEXT , postcode TEXT , seasonality INTEGER , slug TEXT , spaceId TEXT , venueIdOfPreviousOccupant TEXT , website TEXT , latitude DOUBLE PRECISION , longitude DOUBLE PRECISION , numMedia INTEGER , numNewsletters INTEGER , hasFacebook BIT(1) , hasInsta BIT(1) , placeTypeName TEXT , statusTypeName TEXT , primtid TEXT , menuCheckTime TIMESTAMP , jumpNote TEXT , inGeneric BIT(1) , setupTime TIMESTAMP , jumpedTime TIMESTAMP , spoonedTime TIMESTAMP , verifiedTime TIMESTAMP , offeringsValue INTEGER , TagName TEXT , offeringTag TEXT , boundaryName TEXT NOT NULL, boundaryType INTEGER , boundaryAdminLevel INTEGER ) ;
I0918 20:49:04.893347 2451 MapDHandler.cpp:2819] passing query to legacy processor
E0918 20:49:04.902344 2451 MapDHandler.cpp:2839] Syntax error at: BIT
I0918 20:49:04.970685 2451 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 20:54:12.396536 2452 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 20:54:12.464833 2452 MapDHandler.cpp:543] sql_execute :v1FzoZt8Ie7zQTVId90iEkvZoNtPEIdO:query_str:SELECT * FROM venues LIMIT 1 ;
I0918 20:54:12.465173 2452 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM venues LIMIT 1 ;'
E0918 20:54:12.472375 2452 MapDHandler.cpp:2823] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 13: Object ‘venues’ not found
I0918 20:54:12.541826 2452 MapDHandler.cpp:543] sql_execute :v1FzoZt8Ie7zQTVId90iEkvZoNtPEIdO:query_str:CREATE TABLE venues ( id TEXT , address TEXT , createdTime TIMESTAMP NOT NULL, chainId TEXT , contactUrl TEXT , description TEXT , keyword TEXT , modifiedTime TIMESTAMP NOT NULL, name TEXT , postcode TEXT , seasonality INTEGER , slug TEXT , spaceId TEXT , venueIdOfPreviousOccupant TEXT , website TEXT , latitude DOUBLE PRECISION , longitude DOUBLE PRECISION , numMedia INTEGER , numNewsletters INTEGER , placeTypeName TEXT , statusTypeName TEXT , primtid TEXT , menuCheckTime TIMESTAMP , jumpNote TEXT , inGeneric BIT(1) , setupTime TIMESTAMP , jumpedTime TIMESTAMP , spoonedTime TIMESTAMP , verifiedTime TIMESTAMP , offeringsValue INTEGER , TagName TEXT , offeringTag TEXT , boundaryName TEXT NOT NULL, boundaryType INTEGER , boundaryAdminLevel INTEGER ) ;
I0918 20:54:12.541880 2452 MapDHandler.cpp:2819] passing query to legacy processor
E0918 20:54:12.550921 2452 MapDHandler.cpp:2839] Syntax error at: BIT
I0918 20:54:12.619210 2452 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 20:54:28.716837 2454 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 20:54:28.785792 2454 MapDHandler.cpp:543] sql_execute :7eCIn9kn7aRDAp2VjcBQmoNijy7184ll:query_str:SELECT * FROM venues LIMIT 1 ;
I0918 20:54:28.786152 2454 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM venues LIMIT 1 ;'
E0918 20:54:28.795104 2454 MapDHandler.cpp:2823] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 13: Object ‘venues’ not found
I0918 20:54:28.864251 2454 MapDHandler.cpp:543] sql_execute :7eCIn9kn7aRDAp2VjcBQmoNijy7184ll:query_str:CREATE TABLE venues ( id TEXT , address TEXT , createdTime TIMESTAMP NOT NULL, chainId TEXT , contactUrl TEXT , description TEXT , keyword TEXT , modifiedTime TIMESTAMP NOT NULL, name TEXT , postcode TEXT , seasonality INTEGER , slug TEXT , spaceId TEXT , venueIdOfPreviousOccupant TEXT , website TEXT , latitude DOUBLE PRECISION , longitude DOUBLE PRECISION , numMedia INTEGER , numNewsletters INTEGER , placeTypeName TEXT , statusTypeName TEXT , primtid TEXT , menuCheckTime TIMESTAMP , jumpNote TEXT , setupTime TIMESTAMP , jumpedTime TIMESTAMP , spoonedTime TIMESTAMP , verifiedTime TIMESTAMP , offeringsValue INTEGER , TagName TEXT , offeringTag TEXT , boundaryName TEXT NOT NULL, boundaryType INTEGER , boundaryAdminLevel INTEGER ) ;
I0918 20:54:28.864387 2454 MapDHandler.cpp:2819] passing query to legacy processor
I0918 20:54:28.889073 2454 Calcite.cpp:179] Time to updateMetadata 4 (ms)
I0918 20:54:28.889165 2454 MapDHandler.cpp:555] sql_execute-COMPLETED Total: 24 (ms), Execution: 15 (ms)
I0918 20:54:29.530421 2456 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 20:56:47.495932 2454 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 20:56:47.667146 2457 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 20:56:47.735419 2457 MapDHandler.cpp:543] sql_execute :BidcUlwV1TzyeBXx8EHo5Jf3BChqjnTp:query_str:SELECT * FROM venues LIMIT 1 ;
I0918 20:56:47.735787 2457 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM venues LIMIT 1 ;'
I0918 20:56:48.120523 2457 Calcite.cpp:260] Time in Thrift 0 (ms), Time in Java Calcite server 384 (ms)
I0918 20:56:51.889683 13116 BufferMgr.cpp:266] ALLOCATION slab of 8388608 pages (4294967296B) created in 0 ms CPU_MGR:0
I0918 20:56:52.048660 13116 BufferMgr.cpp:266] ALLOCATION slab of 4194304 pages (2147483648B) created in 2 ms GPU_MGR:0
I0918 20:56:52.068213 2457 MapDHandler.cpp:555] sql_execute-COMPLETED Total: 4332 (ms), Execution: 4331 (ms)
I0918 20:58:36.120672 2452 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 20:59:25.723706 2452 MapDHandler.cpp:543] sql_execute :qemtgrcuVzdmLSxbWd5fOCj5i57lDZAd:query_str:SELECT COUNT() as n FROM venues
I0918 20:59:25.724092 2452 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT COUNT(
) as n FROM venues’
I0918 20:59:25.744668 2452 Calcite.cpp:260] Time in Thrift 0 (ms), Time in Java Calcite server 20 (ms)
I0918 20:59:25.811642 2452 MapDHandler.cpp:555] sql_execute-COMPLETED Total: 87 (ms), Execution: 86 (ms)
I0918 21:07:05.034621 2451 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 21:07:07.943600 2451 MapDHandler.cpp:543] sql_execute :uDeGR9lHy9b9mOpY2yfWqJUANaSo3uAe:query_str:SELECT COUNT() as n FROM venues
I0918 21:07:07.943994 2451 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT COUNT(
) as n FROM venues’
I0918 21:07:07.953891 2451 Calcite.cpp:260] Time in Thrift 0 (ms), Time in Java Calcite server 9 (ms)
I0918 21:07:07.961412 2451 MapDHandler.cpp:555] sql_execute-COMPLETED Total: 17 (ms), Execution: 17 (ms)
I0918 21:07:13.632747 2455 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 21:07:13.702600 2455 MapDHandler.cpp:543] sql_execute :T3bwyFecsdg8dUpW3iUB3ZnOPkuQKWl6:query_str:SELECT * FROM venues LIMIT 1 ;
I0918 21:07:13.702925 2455 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM venues LIMIT 1 ;'
I0918 21:07:13.731312 2455 Calcite.cpp:260] Time in Thrift 0 (ms), Time in Java Calcite server 28 (ms)
I0918 21:07:13.744351 2455 MapDHandler.cpp:555] sql_execute-COMPLETED Total: 41 (ms), Execution: 40 (ms)
I0918 21:07:13.815855 2455 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 21:08:27.867193 2454 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 21:08:27.936774 2454 MapDHandler.cpp:543] sql_execute :DywR8p6UdaQBch8DuSc6QYcuVARqtnlP:query_str:SELECT * FROM venues LIMIT 1 ;
I0918 21:08:27.937116 2454 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM venues LIMIT 1 ;'
I0918 21:08:27.965399 2454 Calcite.cpp:260] Time in Thrift 0 (ms), Time in Java Calcite server 28 (ms)
I0918 21:08:27.983312 2454 MapDHandler.cpp:555] sql_execute-COMPLETED Total: 46 (ms), Execution: 45 (ms)
I0918 21:08:28.059460 2454 MapDHandler.cpp:543] sql_execute :DywR8p6UdaQBch8DuSc6QYcuVARqtnlP:query_str:DROP TABLE venues;
I0918 21:08:28.059587 2454 MapDHandler.cpp:2819] passing query to legacy processor
I0918 21:08:31.090525 2454 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I0918 21:08:31.123395 2454 MapDHandler.cpp:555] sql_execute-COMPLETED Total: 3063 (ms), Execution: 3054 (ms)
I0918 21:08:31.193325 2454 MapDHandler.cpp:543] sql_execute :DywR8p6UdaQBch8DuSc6QYcuVARqtnlP:query_str:CREATE TABLE venues ( id TEXT , address TEXT , createdTime TIMESTAMP NOT NULL, chainId TEXT , contactUrl TEXT , description TEXT , keyword TEXT , modifiedTime TIMESTAMP NOT NULL, name TEXT , postcode TEXT , seasonality INTEGER , slug TEXT , spaceId TEXT , venueIdOfPreviousOccupant TEXT , website TEXT , latitude DOUBLE PRECISION , longitude DOUBLE PRECISION , numMedia INTEGER , numNewsletters INTEGER , placeTypeName TEXT , statusTypeName TEXT , primtid TEXT , menuCheckTime TIMESTAMP , jumpNote TEXT , setupTime TIMESTAMP , jumpedTime TIMESTAMP , spoonedTime TIMESTAMP , verifiedTime TIMESTAMP , offeringsValue INTEGER , TagName TEXT , offeringTag TEXT , boundaryName TEXT NOT NULL, boundaryType INTEGER , boundaryAdminLevel INTEGER ) ;
I0918 21:08:31.193353 2454 MapDHandler.cpp:2819] passing query to legacy processor
I0918 21:08:31.220397 2454 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I0918 21:08:31.220465 2454 MapDHandler.cpp:555] sql_execute-COMPLETED Total: 27 (ms), Execution: 18 (ms)

I0918 21:10:43.412878 2451 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 21:10:43.482766 2451 MapDHandler.cpp:543] sql_execute :v7S80VeUVzx2CcFl9z9atV8VmEJtfMmc:query_str:SELECT * FROM venues LIMIT 1 ;
I0918 21:10:43.483075 2451 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM venues LIMIT 1 ;'
I0918 21:10:43.511612 2451 Calcite.cpp:260] Time in Thrift 0 (ms), Time in Java Calcite server 28 (ms)
I0918 21:10:43.633797 2451 MapDHandler.cpp:555] sql_execute-COMPLETED Total: 151 (ms), Execution: 150 (ms)
I0918 21:10:43.708168 2451 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 21:49:19.021690 2458 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 21:49:19.114351 2458 MapDHandler.cpp:543] sql_execute :CvLIf4I2pXuzOKG8NxediB4E7jEN10Mp:query_str:SELECT * FROM features LIMIT 1 ;
I0918 21:49:19.114933 2458 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM features LIMIT 1 ;'
E0918 21:49:19.124438 2458 MapDHandler.cpp:2823] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 15: Object ‘features’ not found
I0918 21:49:19.211269 2458 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 22:00:32.765810 2455 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 22:00:32.857393 2455 MapDHandler.cpp:543] sql_execute :1bWHoez5Te6Lt3pOcabTzy00fTPeoDia:query_str:SELECT * FROM events LIMIT 1 ;
I0918 22:00:32.857957 2455 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM events LIMIT 1 ;'
E0918 22:00:32.863879 2455 MapDHandler.cpp:2823] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 13: Object ‘events’ not found
I0918 22:00:32.949687 2455 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 22:04:43.605583 2456 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 22:04:43.675477 2456 MapDHandler.cpp:543] sql_execute :cfwJCHjcLIO3sVYBDQOdvBawj9hIVO0t:query_str:SELECT * FROM events LIMIT 1 ;
I0918 22:04:43.675950 2456 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM events LIMIT 1 ;'
E0918 22:04:43.683770 2456 MapDHandler.cpp:2823] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 13: Object ‘events’ not found
I0918 22:04:43.754061 2456 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 22:04:48.453287 2454 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 22:04:48.521571 2454 MapDHandler.cpp:543] sql_execute :SE8302h8crhAVZd9rrpuLT9htgN5ieOm:query_str:SELECT * FROM events LIMIT 1 ;
I0918 22:04:48.521986 2454 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM events LIMIT 1 ;'
E0918 22:04:48.529392 2454 MapDHandler.cpp:2823] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 13: Object ‘events’ not found
I0918 22:04:48.598316 2454 MapDHandler.cpp:543] sql_execute :SE8302h8crhAVZd9rrpuLT9htgN5ieOm:query_str:CREATE TABLE events ( id TEXT , created TIMESTAMP NOT NULL, description TEXT , detailUrls TEXT , info TEXT , keywords TEXT , modified TIMESTAMP NOT NULL, name TEXT , published BIT(1) , restriction TEXT , slug TEXT , source TEXT , tids TEXT , ticketUrl TEXT , venueId TEXT , videoUrl TEXT , numMedia INTEGER , primtid TEXT , oneTimeOccurrenceStart TIMESTAMP , oneTimeOccurrenceFinish TIMESTAMP , priceCurrency TEXT , priceDetail TEXT , priceValue DOUBLE PRECISION ) ;
I0918 22:04:48.598428 2454 MapDHandler.cpp:2819] passing query to legacy processor
E0918 22:04:48.607578 2454 MapDHandler.cpp:2839] Syntax error at: BIT
I0918 22:04:48.675959 2454 MapDHandler.cpp:357] User mapd disconnected from database mapd
I0918 22:05:04.341956 2452 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 22:05:04.412292 2452 MapDHandler.cpp:543] sql_execute :rIzeO9DqW9ICjd7Yz17a9ghwzucLraqa:query_str:SELECT * FROM events LIMIT 1 ;
I0918 22:05:04.412628 2452 Calcite.cpp:247] User mapd catalog mapd sql 'SELECT * FROM events LIMIT 1 ;'
E0918 22:05:04.417615 2452 MapDHandler.cpp:2823] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 13: Object ‘events’ not found
I0918 22:05:04.488256 2452 MapDHandler.cpp:543] sql_execute :rIzeO9DqW9ICjd7Yz17a9ghwzucLraqa:query_str:CREATE TABLE events ( id TEXT , created TIMESTAMP NOT NULL, description TEXT , detailUrls TEXT , info TEXT , keywords TEXT , modified TIMESTAMP NOT NULL, name TEXT , restriction TEXT , slug TEXT , source TEXT , tids TEXT , ticketUrl TEXT , venueId TEXT , videoUrl TEXT , numMedia INTEGER , primtid TEXT , oneTimeOccurrenceStart TIMESTAMP , oneTimeOccurrenceFinish TIMESTAMP , priceCurrency TEXT , priceDetail TEXT , priceValue DOUBLE PRECISION ) ;
I0918 22:05:04.488312 2452 MapDHandler.cpp:2819] passing query to legacy processor
I0918 22:05:04.510094 2452 Calcite.cpp:179] Time to updateMetadata 0 (ms)
I0918 22:05:04.510162 2452 MapDHandler.cpp:555] sql_execute-COMPLETED Total: 21 (ms), Execution: 12 (ms)
I0918 22:05:05.090922 2457 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 22:05:05.091084 2451 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 22:05:05.092172 2458 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 22:05:05.101989 2455 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 22:05:05.102847 2456 MapDHandler.cpp:347] User mapd connected to database mapd
I0918 22:05:05.103054 2454 MapDHandler.cpp:347] User mapd connected to database mapd
E0918 22:05:06.267753 2457 MapDHandler.cpp:1543] Input exception thrown: String too long for column description was 60633 max is 32767. Row discarded, issue at column : 3 data :TStringRow(cols=[TStringValue(str_val=5983175affa36100047a5388, is_null=0), TStringValue(str_val=2017-08-03 12:30:18.006, is_null=0), TStringValue(str_val=
Chuck Mitchell
Born Charles Scott Mitchell in New York City, he grew up in farm country north of Detroit. He thought of becoming a forest ranger like Aldo Leopold. Instead, he graduated from college with a degree in English and drama.
After a brief time pursuing but not capturing an acting career in New York, Mitchell was drafted into the US Army, where he learned to drive a tank and use an assortment of weapons. Then he spent a peaceful year in Korea as a reporter for Stars & Stripes and as a hoofer in musical comedy reviews, entertaining the troops.
Mitchell returned to Detroit and became a writer for the Great Cities project, a public school experiment bankrolled by the Ford Foundation to develop programs for educating “culturally deprived” children. A program called Head Start was one.

E0918 22:05:12.763067 2458 MapDHandler.cpp:1543] Input exception thrown: String too long for column description was 34599 max is 32767. Row discarded, issue at column : 3 data :TStringRow(cols=[TStringValue(str_val=58a4567371ac42000438f81c, is_null=0), TStringValue(str_val=2017-02-15 13:24:03.803, is_null=0), TStringValue(str_val=


#7

Could it be that the length of the string in one of the columns is causing some type of error? I’m going to try and cut that down and retry but let me know if that error log makes sense to you


#8

Hi

No, I don’t think the length of some of these strings would cause your issue. The row with really long strings are just being rejected.

Will need to see some more of the log to be able to help out. You should be able to upload the entire file rather than having to paste it into the text boxes

Regards


#9

mapd_server.txt.zip (582.9 KB)