Recall: spark sql in-clause problem

2018-05-23 Thread Shiva Prashanth Vallabhaneni
Shiva Prashanth Vallabhaneni would like to recall the message, "spark sql in-clause problem". Any comments or statements made in this email are not necessarily those of Tavant Technologies. The information transmitted is intended only for the person

RE: spark sql in-clause problem

2018-05-22 Thread Shiva Prashanth Vallabhaneni
uery; Table coordinates ( Integer X, Integer Y ) sparkSqlContext.sql(select * from mytable where key = 1 and (X,Y) IN (select X, Y from coordinates)) From: onmstester onmstester <onmstes...@zoho.com> Sent: Wednesday, May 23, 2018 10:33 AM To: user <user@spark.apache.org> Subject: spa

spark sql in-clause problem

2018-05-22 Thread onmstester onmstester
I'm reading from this table in cassandra: Table mytable ( Integer Key, Integer X, Interger Y Using: sparkSqlContext.sql(select * from mytable where key = 1 and (X,Y) in ((1,2),(3,4))) Encountered error: StructType(StructField((X,IntegerType,true),StructField((Y,IntegerType,true))