executeQuery error


#1

when I execute sql “select * from ka_042f7b770d239ee8fb358a_tmp
b,ka_de7c82295e518808121dae_tmp c where b.gmsfhm=c.sfzhm” ,it report:
org.apache.thrift.transport.TTransportException
at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132)
at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86)
at org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:424)
at org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:321)
at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:225)
at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:77)
at com.mapd.thrift.server.MapD$Client.recv_sql_execute(MapD.java:726)
at com.mapd.thrift.server.MapD$Client.sql_execute(MapD.java:708)
at com.mapd.jdbc.MapDStatement.executeQuery(MapDStatement.java:67)
at com.liu.mapd.MapDTest.main(MapDTest.java:36)


#2

Hi,

The message your are showing is just the client side error of a server failure.

Please include the contents of mapd_server.INFO to help us diagnose your issue

Do you really mean to be doing a cross product join with no join criteria?

regards


#3

It’s not a Cartesian product; two tables and a join condition


#4

Hi,

@aznable you are correct, I misread the query.

regards


#5

Yap because of the strange names of tables and the aliases starting aliases with b leads to think there is a cartesia product; anyway the contents fields used on join would result on a near-Cartesian product too