Select on similar values


#1

Hi all,

I’d like to create a table out of 2 different tables if they have similar values in a column.
The command i’m using just to check if values are similar is pretty straight forward, so I’m not sure why’s it’s not working.

to check: select A.*, B.thing from TableA A, TableB B where A.uid = B.uid
to create table: create table TableC as (above statement)

I know for a fact that there are multiple uid’s in both tables that are alike, however, when I run the above command I get a query of only one row, or multiple rows with the same uid (so only 1 or 2 distinct uids)

I thought it was the fact that uid was a TEXT ENCODING DICT (32) type but then made new tables to test the queries (2 TEXT v 2 TEXT ENCODING DICT (32)) and both of them worked as expected.

Any help would be awesome

Thanks,


#2

Hi,

How does your data differ from this simple test?

mapdql> create table A (uid text, f1 int);
mapdql> create table B (uid text, thing int);
mapdql> insert into A values ('k1', 1);
mapdql> insert into A values ('k2', 2);
mapdql> insert into A values ('k3', 3);
mapdql> insert into B values ('k1', 100);
mapdql> insert into B values ('k1', 101);
mapdql> insert into B values ('k2', 200);
mapdql> select A.*, B.thing from A,B where A.uid=B.uid;
uid|f1|rowid|thing
k1|1|0|100
k1|1|0|101
k2|2|1|200
mapdql> insert into A values ('k1', 11);
mapdql> select A.*, B.thing from A,B where A.uid=B.uid;
uid|f1|rowid|thing
k1|1|0|100
k1|1|0|101
k2|2|1|200
k1|11|3|100
k1|11|3|101

Can you share a simple snippet like the one above to give an example of your issue

Regards


#3

Thank you for your reply @dwayneberry
My data differs in that my tables were created via the import data option MapD has, table A has 21 columns and 902707 rows, my table B has 2 columns and 1432204 rows, I’m inserting via a Kafka stream insert, and my uid is a TEXT ENCODING DICT(32)
I can’t really put a snippet in because the steam insert is happening from another script and then when it comes to selecting from the table, I’ve been using the exact code you are using but replace table A and B with my tables.

Thanks,


#4

Hi,

You should still be able to select a few rows which you have loaded and perform the same kind of investigation,

A simple select a uid from table A and table B which show a single column from each plus the uid,

Then show a simple example of the failing join on those same rows.

regards


#5

Not entirely sure I understand but I selected a few rows from each column, did the join and only 2 unique uids are shown, and then I took a uid from one table and found it in another (but that uid is not shown in the join). I also ran a query so you can see how many unique id’s are in the tables.

mapdql> select * from Live_Table limit 5;
conn_state|duration|history|Source|Source_Port|Destination|Destination_Port|local_orig|local_resp|missed_bytes|orig_bytes|orig_ip_bytes|orig_pkts|Protocol|resp_bytes|resp_ip_bytes|resp_pkts|service|ts|tunnel_parents|uid
RSTR|68.044342|ShADdFar|192.168.202.79|33182|192.168.229.153|445|True|True|0|332|808|9|tcp|583|891|6|NULL|1511803654.258959|[]|CYbH2R2reidoK0RzUa
SF|40.243997|ShADdFf|192.168.202.79|47107|192.168.229.251|445|True|True|0|332|860|10|tcp|568|840|5|NULL|1511803654.280429|[]|CypKCy1b3CZa0ZslV
RSTR|9.1e-05|Far|192.168.202.79|37584|192.168.229.252|445|True|True|0|0|52|1|tcp|0|92|2|NULL|1511803654.236499|[]|CO0JTe26kjkYEBu5tl
RSTR|67.703903|ShADdFar|192.168.202.79|33198|192.168.229.153|445|True|True|0|332|808|9|tcp|583|891|6|NULL|1511803654.258959|[]|CxNmv9Rbee8dnBKsb
RSTR|47.359679|ShADdFar|192.168.202.79|34064|192.168.229.153|445|True|True|0|332|808|9|tcp|583|891|6|NULL|1511803654.280429|[]|C05rNu4Da2M9i7BSh3
mapdql> select * from kates_output limit 5;
uid|prob

Ck2tkz4P5PU98Duvac|1.000000

CqktYB3dj0UnbgNbZ7|1.000000

CNL6Un3zYHD4X4CeUi|1.000000

Cv5KwJ24yZQuKfZlRe|1.000000

C9tWjQ255u7oinhkG2|1.000000
mapdql> select count(distinct uid) from Live_Table;
EXPR$0
628224
mapdql> select count(distinct uid) from kates_output;
EXPR$0
712204
mapdql> select A.*, B.prob from Live_Table A, kates_output B where A.uid = B.uid;
conn_state|duration|history|Source|Source_Port|Destination|Destination_Port|local_orig|local_resp|missed_bytes|orig_bytes|orig_ip_bytes|orig_pkts|Protocol|resp_bytes|resp_ip_bytes|resp_pkts|service|ts|tunnel_parents|uid|rowid|prob
S0|3.002255|S|192.168.202.89|2071|176.9.106.116|9001|True|True|0|0|104|2|tcp|0|0|0|NULL|1511803627.125445|[]|CBX0682MdWjASsbW93|8178|0.000977
S0|3.002255|S|192.168.202.89|2071|176.9.106.116|9001|True|True|0|0|104|2|tcp|0|0|0|NULL|1511803627.125445|[]|CBX0682MdWjASsbW93|12328|0.000977
S0|3.002255|S|192.168.202.89|2071|176.9.106.116|9001|True|True|0|0|104|2|tcp|0|0|0|NULL|1511803627.125445|[]|CBX0682MdWjASsbW93|71|0.000977
S0|3.002255|S|192.168.202.89|2071|176.9.106.116|9001|True|True|0|0|104|2|tcp|0|0|0|NULL|1511803627.125445|[]|CBX0682MdWjASsbW93|2075|0.000977
S0|3.002255|S|192.168.202.89|2071|176.9.106.116|9001|True|True|0|0|104|2|tcp|0|0|0|NULL|1511803627.125445|[]|CBX0682MdWjASsbW93|10252|0.000977
S0|3.002255|S|192.168.202.89|2071|176.9.106.116|9001|True|True|0|0|104|2|tcp|0|0|0|NULL|1511803627.125445|[]|CBX0682MdWjASsbW93|6138|0.000977
S0|3.002255|S|192.168.202.89|2071|176.9.106.116|9001|True|True|0|0|104|2|tcp|0|0|0|NULL|1511803627.125445|[]|CBX0682MdWjASsbW93|4106|0.000977
S0|3.001518|S|192.168.202.76|51668|149.5.45.166|33033|True|True|0|0|104|2|tcp|0|0|0|NULL|1511878838.45863|[]|C7sVtr2I19Gw2rWCx|91202|0.000977
S0|3.001518|S|192.168.202.76|51668|149.5.45.166|33033|True|True|0|0|104|2|tcp|0|0|0|NULL|1511878838.45863|[]|C7sVtr2I19Gw2rWCx|91202|0.000977
S0|3.001518|S|192.168.202.76|51668|149.5.45.166|33033|True|True|0|0|104|2|tcp|0|0|0|NULL|1511878838.45863|[]|C7sVtr2I19Gw2rWCx|91202|0.000977
S0|3.001518|S|192.168.202.76|51668|149.5.45.166|33033|True|True|0|0|104|2|tcp|0|0|0|NULL|1511878838.45863|[]|C7sVtr2I19Gw2rWCx|339202|0.000977
S0|3.001518|S|192.168.202.76|51668|149.5.45.166|33033|True|True|0|0|104|2|tcp|0|0|0|NULL|1511878838.45863|[]|C7sVtr2I19Gw2rWCx|339202|0.000977
S0|3.001518|S|192.168.202.76|51668|149.5.45.166|33033|True|True|0|0|104|2|tcp|0|0|0|NULL|1511878838.45863|[]|C7sVtr2I19Gw2rWCx|339202|0.000977
mapdql> 

As seen in last query from above, only 2 unique id’s present which is not true. As seen below.

mapdql> select * from kates_output order by prob asc limit 5;
uid|prob

CAm2EW13zQ4VAX01V2|0.000977

CTZ3M92dN9o0fWxR3b|0.000977

Cp342U1aiah5Y7CQw2|0.000977

CbcN3736978BMqtVZd|0.000977

CsiPGl1EPYmqVMCwT6|0.000977
mapdql> select * from Live_Table where uid = 'CAm2EW13zQ4VAX01V2';
conn_state|duration|history|Source|Source_Port|Destination|Destination_Port|local_orig|local_resp|missed_bytes|orig_bytes|orig_ip_bytes|orig_pkts|Protocol|resp_bytes|resp_ip_bytes|resp_pkts|service|ts|tunnel_parents|uid
SF|0.010062|ShADadFfrRR|192.168.202.76|52964|192.168.22.254|443|True|True|0|559|1051|12|tcp|1058|1666|15|ssl|1511880354.440796|[]|CAm2EW13zQ4VAX01V2
mapdql> 

#6

Hi,

Thanks for the additional info.

How many total rows does each table contain?

Are you running the latest v3.3.1 release? You can check the version via mapdql \version command or by looking in the mapd_server.INFO log

regards


#7
mapdql> \version
MapD Server Version: 3.2.3-20170922-fbc71bb
mapdql> select count(*) from Live_Table;
EXPR$0
902707
mapdql> select count(*) from kates_output;
EXPR$0
1432204
mapdql> 

#8

Hi

Please update to the latest v3.3.1 release and retry your testing

regards


#9

Will updating to the latest version effect any current data?

Thank you,


#10

Hi,

No, it should not effect any current data, but always a good idea to have backups if you are concerned.

regards


#11

What’s the best way to update everything? Might save me some time instead of digging through documentation but all good if you don’t know off the top of your head.

Thanks for all of the help


#12

Hi,

Depending on how you installed it could be as easy as running 'yum update`

The steps are detailed in the documentation https://www.mapd.com/docs/latest/getting-started/upgrading/

regards


#13

Running into some errors when updating. I’m trying to figure it out but I also posted a question: Error Updating MapD Core
I’ll get back to you with results when I’m able to update


#14

Finally resolved the update issue which was way more complex than it should have been (of course, nothing is ever as easy as it is supposed to be in the tech world).
But doing the update didn’t solve my problem @dwayneberry

Any thoughts?

Thanks,


#15

Hi,

Hmm, its not adding up is it?

From mapdql could you please run the following

\version
select uid from Live_Table where uid = 'CAm2EW13zQ4VAX01V2';
select uid from kates_output where uid = 'CAm2EW13zQ4VAX01V2';
select A.uid, B.uid from Live_Table A, kates_output B where A.uid = B.uid and a.uid = 'CAm2EW13zQ4VAX01V2';
select A.uid, B.uid from Live_Table A, kates_output B where A.uid = B.uid;

Please include the full mapd_server.INFO log with the results.

regards


#16

Note: I changed the name of kates_output to bayesian_score

mapdql> \version
MapD Server Version: 3.3.1-20171108-32e7bcc
mapdql> select uid from Live_Table where uid = 'CAm2EW13zQ4VAX01V2';
uid
CAm2EW13zQ4VAX01V2
mapdql> select uid from bayesian_score where uid = 'CAm2EW13zQ4VAX01V2';
No rows returned.
mapdql> select A.uid, B.uid from Live_Table A, kates_output B where A.uid = B.uid and a.uid = 'CAm2EW13zQ4VAX01V2';
Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 3, column 1 to line 3, column 14: Object 'kates_output' not found
mapdql> 
mapdql> select A.uid, B.uid from Live_Table A, bayesian_score B where A.uid = B.uid and a.uid = 'CAm2EW13zQ4VAX01V2';
No rows returned.
mapdql> select A.uid, B.uid from Live_Table A, bayesian_score B where A.uid = B.uid;
uid|uid0
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
C7sVtr2I19Gw2rWCx|C7sVtr2I19Gw2rWCx
C7sVtr2I19Gw2rWCx|C7sVtr2I19Gw2rWCx
C7sVtr2I19Gw2rWCx|C7sVtr2I19Gw2rWCx
C7sVtr2I19Gw2rWCx|C7sVtr2I19Gw2rWCx
C7sVtr2I19Gw2rWCx|C7sVtr2I19Gw2rWCx
C7sVtr2I19Gw2rWCx|C7sVtr2I19Gw2rWCx
mapdql> 

Here is the mapd_server.INFO log. I cut off everything before this because it looked like way older commands:

I1220 21:01:58.891937 24381 MapDHandler.cpp:349] User mapd connected to database cyberanalytics
I1220 21:02:10.286630 24381 MapDHandler.cpp:568] sql_execute :x7x8t1hFhtbTG5mZLJXBhZr2imSod8Ia:query_str:select uid from Live_Table where uid = 'CAm2EW13zQ4VAX01V2';
I1220 21:02:10.287053 24381 Calcite.cpp:247] User mapd catalog cyberanalytics sql 'select uid from Live_Table where uid = 'CAm2EW13zQ4VAX01V2';'
I1220 21:02:10.297238 24381 Calcite.cpp:260] Time in Thrift 0 (ms), Time in Java Calcite server 10 (ms)
I1220 21:02:10.310482 24381 MapDHandler.cpp:586] sql_execute-COMPLETED Total: 23 (ms), Execution: 23 (ms)
I1220 21:02:26.960528 24381 MapDHandler.cpp:568] sql_execute :x7x8t1hFhtbTG5mZLJXBhZr2imSod8Ia:query_str:select uid from bayesian_score where uid = 'CAm2EW13zQ4VAX01V2';
I1220 21:02:26.960961 24381 Calcite.cpp:247] User mapd catalog cyberanalytics sql 'select uid from bayesian_score where uid = 'CAm2EW13zQ4VAX01V2';'
I1220 21:02:26.970890 24381 Calcite.cpp:260] Time in Thrift 0 (ms), Time in Java Calcite server 9 (ms)
I1220 21:02:26.999969 24381 MapDHandler.cpp:586] sql_execute-COMPLETED Total: 39 (ms), Execution: 38 (ms)
I1220 21:03:25.660514 24381 MapDHandler.cpp:568] sql_execute :x7x8t1hFhtbTG5mZLJXBhZr2imSod8Ia:query_str:select A.uid, B.uid from Live_Table A, kates_output B where A.uid = B.uid and a.uid = 'CAm2EW13zQ4VAX01V2';
I1220 21:03:25.660967 24381 Calcite.cpp:247] User mapd catalog cyberanalytics sql 'select A.uid, B.uid from Live_Table A, kates_output B where A.uid = B.uid and a.uid = 'CAm2EW13zQ4VAX01V2';'
E1220 21:03:25.670985 24381 MapDHandler.cpp:3260] Exception: Exception occurred: org.apache.calcite.runtime.CalciteContextException: From line 3, column 1 to line 3, column 14: Object 'kates_output' not found
I1220 21:03:38.941817 24381 MapDHandler.cpp:568] sql_execute :x7x8t1hFhtbTG5mZLJXBhZr2imSod8Ia:query_str:select A.uid, B.uid from Live_Table A, bayesian_score B where A.uid = B.uid and a.uid = 'CAm2EW13zQ4VAX01V2';
I1220 21:03:38.942250 24381 Calcite.cpp:247] User mapd catalog cyberanalytics sql 'select A.uid, B.uid from Live_Table A, bayesian_score B where A.uid = B.uid and a.uid = 'CAm2EW13zQ4VAX01V2';'
I1220 21:03:38.953963 24381 Calcite.cpp:260] Time in Thrift 0 (ms), Time in Java Calcite server 11 (ms)
I1220 21:03:40.059551 24381 MapDHandler.cpp:586] sql_execute-COMPLETED Total: 1117 (ms), Execution: 1117 (ms)
I1220 21:03:56.142405 24381 MapDHandler.cpp:568] sql_execute :x7x8t1hFhtbTG5mZLJXBhZr2imSod8Ia:query_str:select A.uid, B.uid from Live_Table A, bayesian_score B where A.uid = B.uid;
I1220 21:03:56.142830 24381 Calcite.cpp:247] User mapd catalog cyberanalytics sql 'select A.uid, B.uid from Live_Table A, bayesian_score B where A.uid = B.uid;'
I1220 21:03:56.151922 24381 Calcite.cpp:260] Time in Thrift 1 (ms), Time in Java Calcite server 8 (ms)
I1220 21:03:56.298729 24381 MapDHandler.cpp:586] sql_execute-COMPLETED Total: 156 (ms), Execution: 155 (ms)
I1220 21:05:02.909919 24381 MapDHandler.cpp:359] User mapd disconnected from database cyberanalytics

If more of the log is needed please let me know.
Thanks for continuing to follow up.


#17

Hi,

Yes we need to see the start of the log where it reports the parameters in use and the current version.

please stop and restart the mapd_server and send a clean log start to finish with these quieries.

It appears that the uid specified does not exist in both tables. please find a case where it does and show the issue with my simple commands.

regards


#18

So it does exist in one of the tables (Live_Table but not bayesian_score – which is the new kates_output)

mapdql> select uid from Live_Table where uid = 'CAm2EW13zQ4VAX01V2';
uid
CAm2EW13zQ4VAX01V2

However, I will restart the server and get you the new log file as soon

Thanks,


#19

Hi,

The issue was that a join did not find data in both tables, you need to find a uid in booth tables to get output from an inner join.

Please find a uid that exists in both tables to try to reproduce the error.

regards


#20
Disconnected from database mapd
User mapd connected to database cyberanalytics
mapdql> select uid from Live_Table where uid = 'CBX0682MdWjASsbW93';
uid
CBX0682MdWjASsbW93
CBX0682MdWjASsbW93
CBX0682MdWjASsbW93
CBX0682MdWjASsbW93
CBX0682MdWjASsbW93
CBX0682MdWjASsbW93
CBX0682MdWjASsbW93
mapdql> select uid from bayesian_score where uid = 'CBX0682MdWjASsbW93';
uid
CBX0682MdWjASsbW93
mapdql> select A.uid, B.uid from Live_Table A, bayesian_score B where A.uid = B.uid and a.uid = 'CBX0682MdWjASsbW93';
uid|uid0
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
mapdql> select A.uid, B.uid from Live_Table A, bayesian_score B where A.uid = B.uid;
uid|uid0
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
CBX0682MdWjASsbW93|CBX0682MdWjASsbW93
C7sVtr2I19Gw2rWCx|C7sVtr2I19Gw2rWCx
C7sVtr2I19Gw2rWCx|C7sVtr2I19Gw2rWCx
C7sVtr2I19Gw2rWCx|C7sVtr2I19Gw2rWCx
C7sVtr2I19Gw2rWCx|C7sVtr2I19Gw2rWCx
C7sVtr2I19Gw2rWCx|C7sVtr2I19Gw2rWCx
C7sVtr2I19Gw2rWCx|C7sVtr2I19Gw2rWCx
mapdql> \version
MapD Server Version: 3.3.1-20171108-32e7bcc
mapdql> 

mapd_server.INFO

Log file created at: 2017/12/21 16:32:57
Running on machine: ip-10-194-30-228.csn.internal
Log line format: [IWEF]mmdd hh:mm:ss.uuuuuu threadid file:line] msg
I1221 16:32:57.065527 27180 MapDServer.cpp:606] MapD started with data directory at '/raidStorage/prod/mapd-storage/data'
I1221 16:32:57.065754 27180 MapDServer.cpp:613]  Watchdog is set to 1
I1221 16:32:57.065762 27180 MapDServer.cpp:635]  cuda block size 0
I1221 16:32:57.065765 27180 MapDServer.cpp:636]  cuda grid size  0
I1221 16:32:57.065768 27180 MapDServer.cpp:637]  calcite JVM max memory  1024
I1221 16:32:57.065773 27180 MapDServer.cpp:638]  MapD Server Port  8000
I1221 16:32:57.065775 27180 MapDServer.cpp:639]  MapD Calcite Port  9093
I1221 16:32:57.065815 27180 MapDHandler.cpp:151] MapD Server 3.3.1-20171108-32e7bcc
I1221 16:32:57.155170 27180 CudaMgr.cpp:127] Using 1 Gpus.
I1221 16:32:57.155295 27180 DataMgr.cpp:120] cpuSlabSize is 4096M
I1221 16:32:57.155318 27180 DataMgr.cpp:122] reserved GPU memory is 2035.35M includes render buffer allocation
I1221 16:32:57.155329 27180 DataMgr.cpp:132] gpuSlabSize is 2048M
I1221 16:32:57.155439 27180 FileMgr.cpp:173] Completed Reading table's file metadata, Elasped time : 0ms Epoch: 1 files read: 0 table location: '/raidStorage/prod/mapd-storage/data/mapd_data/table_0_0/'
I1221 16:32:57.155467 27180 Calcite.cpp:156] Creating Calcite Handler,  Calcite Port is 9093 base data dir is /raidStorage/prod/mapd-storage/data
I1221 16:32:57.155474 27180 Calcite.cpp:95] Running calcite server as a daemon
I1221 16:32:57.369441 27180 Calcite.cpp:124] Calcite server start took 200 ms 
I1221 16:32:57.369485 27180 Calcite.cpp:125] ping took 10 ms 
I1221 16:32:57.374652 27180 Calcite.cpp:281] [{"name":"Tan","ret":"double","args":["double"]},{"name":"Truncate__","ret":"float","args":["float","i32"]},{"name":"ln","ret":"double","args":["double"]},{"name":"distance_in_meters__","ret":"double","args":["float","float","float","float"]},{"name":"Floor__","ret":"float","args":["float"]},{"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":"Truncate","ret":"double","args":["double","i32"]},{"name":"Floor__1","ret":"i16","args":["i16"]},{"name":"radians","ret":"double","args":["double"]},{"name":"degrees","ret":"double","args":["double"]},{"name":"Ceil__","ret":"float","args":["float"]},{"name":"ln__","ret":"double","args":["float"]},{"name":"approx_distance_in_meters","ret":"double","args":["float","float","float","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":"Ceil__2","ret":"i32","args":["i32"]},{"name":"Ceil__1","ret":"i16","args":["i16"]},{"name":"Ceil__3","ret":"i64","args":["i64"]},{"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":"Log10","ret":"double","args":["double"]},{"name":"Truncate__1","ret":"i16","args":["i16","i32"]},{"name":"Truncate__2","ret":"i32","args":["i32","i32"]},{"name":"Log","ret":"double","args":["double"]},{"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":"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":"pi","ret":"double","args":[]},{"name":"Sin","ret":"double","args":["double"]},{"name":"Ceil","ret":"double","args":["double"]},{"name":"Exp","ret":"double","args":["double"]}]
I1221 16:32:57.374910 27180 MapDHandler.cpp:196] Started in GPU mode
I1221 16:32:57.387284 27180 EglGLWindow.cpp:107] Window Setting: DRAWABLE_TYPE: PBUFFER.
I1221 16:32:57.387354 27180 EglUtils.cpp:61] EGL Setting: BITS_RGBA = 8.
I1221 16:32:57.387367 27180 EglUtils.cpp:84] EGL Setting: BITS_ALPHA = 8.
I1221 16:32:57.387425 27180 EglGLRenderer.cpp:101] Renderer Setting: USE_CORE_PROFILE: True.
I1221 16:32:57.408737 27180 EglGLRenderer.cpp:170] Renderer Setting: <OPENGL_MAJOR>.<OPENGL_MINOR>: 4.5.
I1221 16:32:57.484896 27180 QueryRenderManager.cpp:451] QueryRenderManager initialized for rendering. start GPU: 0, num GPUs: 1, Render cache limit: 500
I1221 16:32:59.162259 27207 LdapServer.cpp:12] No LDAP server defined, will not attempt to authenticate via ldap
I1221 16:32:59.163815 27207 MapDHandler.cpp:349] User mapd connected to database mapd
I1221 16:33:29.285043 27207 MapDHandler.cpp:359] User mapd disconnected from database mapd
I1221 16:33:29.285445 27207 LdapServer.cpp:12] No LDAP server defined, will not attempt to authenticate via ldap
I1221 16:33:29.305156 27207 MapDHandler.cpp:349] User mapd connected to database cyberanalytics
I1221 16:33:47.077240 27207 MapDHandler.cpp:568] sql_execute :YTjoZK1BCzPTzSY2qZdlN2cX8cRXZA3h:query_str:select uid from Live_Table where uid = 'CBX0682MdWjASsbW93';
I1221 16:33:47.077675 27207 Calcite.cpp:247] User mapd catalog cyberanalytics sql 'select uid from Live_Table where uid = 'CBX0682MdWjASsbW93';'
I1221 16:33:47.741883 27248 FileMgr.cpp:173] Completed Reading table's file metadata, Elasped time : 12ms Epoch: 579 files read: 4 table location: '/raidStorage/prod/mapd-storage/data/mapd_data/table_2_39/'
I1221 16:33:47.760807 27248 Catalog.cpp:1525] Instantiating Fragmenter for table Live_Table took 31ms
I1221 16:33:47.771838 27248 Catalog.cpp:1571] Time to load Dictionary 140 was 10ms
I1221 16:33:47.783370 27248 Catalog.cpp:1571] Time to load Dictionary 141 was 11ms
I1221 16:33:47.793293 27248 Catalog.cpp:1571] Time to load Dictionary 142 was 9ms
I1221 16:33:47.803580 27248 Catalog.cpp:1571] Time to load Dictionary 143 was 10ms
I1221 16:33:47.813760 27248 Catalog.cpp:1571] Time to load Dictionary 144 was 10ms
I1221 16:33:47.823956 27248 Catalog.cpp:1571] Time to load Dictionary 145 was 10ms
I1221 16:33:47.834275 27248 Catalog.cpp:1571] Time to load Dictionary 146 was 10ms
I1221 16:33:47.844410 27248 Catalog.cpp:1571] Time to load Dictionary 147 was 10ms
I1221 16:33:47.854719 27248 Catalog.cpp:1571] Time to load Dictionary 148 was 10ms
I1221 16:33:47.864929 27248 Catalog.cpp:1571] Time to load Dictionary 149 was 10ms
I1221 16:33:47.875319 27248 Catalog.cpp:1571] Time to load Dictionary 150 was 10ms
I1221 16:33:47.887229 27248 Catalog.cpp:1571] Time to load Dictionary 151 was 11ms
I1221 16:33:47.897477 27248 Catalog.cpp:1571] Time to load Dictionary 152 was 10ms
I1221 16:33:47.951375 27248 Catalog.cpp:1571] Time to load Dictionary 153 was 53ms
I1221 16:33:48.157841 27207 Calcite.cpp:260] Time in Thrift 7 (ms), Time in Java Calcite server 1073 (ms)
I1221 16:33:48.209031  2722 BufferMgr.cpp:266] ALLOCATION slab of 4194304 pages (2147483648B) created in 2 ms GPU_MGR:0
I1221 16:33:48.209092  2722 BufferMgr.cpp:266] ALLOCATION slab of 8388608 pages (4294967296B) created in 0 ms CPU_MGR:0
I1221 16:33:48.300102 27207 MapDHandler.cpp:586] sql_execute-COMPLETED Total: 1222 (ms), Execution: 1222 (ms)
I1221 16:33:57.649713 27207 MapDHandler.cpp:568] sql_execute :YTjoZK1BCzPTzSY2qZdlN2cX8cRXZA3h:query_str:select uid from bayesian_score where uid = 'CBX0682MdWjASsbW93';
I1221 16:33:57.650128 27207 Calcite.cpp:247] User mapd catalog cyberanalytics sql 'select uid from bayesian_score where uid = 'CBX0682MdWjASsbW93';'
I1221 16:33:57.668967  2734 FileMgr.cpp:173] Completed Reading table's file metadata, Elasped time : 5ms Epoch: 981 files read: 2 table location: '/raidStorage/prod/mapd-storage/data/mapd_data/table_2_35/'
I1221 16:33:57.671607  2734 Catalog.cpp:1525] Instantiating Fragmenter for table bayesian_score took 8ms
I1221 16:33:57.730630  2734 Catalog.cpp:1571] Time to load Dictionary 122 was 58ms
I1221 16:33:57.735893 27207 Calcite.cpp:260] Time in Thrift 1 (ms), Time in Java Calcite server 84 (ms)
I1221 16:33:57.815160 27207 MapDHandler.cpp:586] sql_execute-COMPLETED Total: 165 (ms), Execution: 165 (ms)
I1221 16:34:48.605692 27207 MapDHandler.cpp:568] sql_execute :YTjoZK1BCzPTzSY2qZdlN2cX8cRXZA3h:query_str:select A.uid, B.uid from Live_Table A, bayesian_score B where A.uid = B.uid and a.uid = 'CBX0682MdWjASsbW93';
I1221 16:34:48.606109 27207 Calcite.cpp:247] User mapd catalog cyberanalytics sql 'select A.uid, B.uid from Live_Table A, bayesian_score B where A.uid = B.uid and a.uid = 'CBX0682MdWjASsbW93';'
I1221 16:34:48.673918 27207 Calcite.cpp:260] Time in Thrift 2 (ms), Time in Java Calcite server 65 (ms)
I1221 16:34:49.680042 27207 MapDHandler.cpp:586] sql_execute-COMPLETED Total: 1074 (ms), Execution: 1073 (ms)
I1221 16:35:16.933856 27207 MapDHandler.cpp:568] sql_execute :YTjoZK1BCzPTzSY2qZdlN2cX8cRXZA3h:query_str:select A.uid, B.uid from Live_Table A, bayesian_score B where A.uid = B.uid;
I1221 16:35:16.934239 27207 Calcite.cpp:247] User mapd catalog cyberanalytics sql 'select A.uid, B.uid from Live_Table A, bayesian_score B where A.uid = B.uid;'
I1221 16:35:16.953408 27207 Calcite.cpp:260] Time in Thrift 0 (ms), Time in Java Calcite server 19 (ms)
I1221 16:35:17.096957 27207 MapDHandler.cpp:586] sql_execute-COMPLETED Total: 163 (ms), Execution: 162 (ms)
I1221 16:36:29.192559 27207 MapDHandler.cpp:359] User mapd disconnected from database cyberanalytics