We are in process of getting SQL implemented (esql).
So this works now - Select col1 from table1 t1 where NOT exists
and you can see if you make a run time field for this select col1 from table1 t2 where t1.col1=t2.col1 and t1.date = t2.date and see if your query works?
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.