Cassandra plugin in drill

2016-04-14 Thread soujanya metta
HI, We have the urgent requirement to querying the cassandra on top of drill. For that purpose I’m following as mentioned in http://www.confusedcoders.com/bigdata/apache-drill/sql-on-cassandra-querying-cassandra-via-apache-drill

Re: Cassandra plugin in drill

2016-04-14 Thread Yash Sharma
Yes i was wondering if you could use hbase instead of Cassandra since it is very similar to Cassandra.. Else you could use some other execution engine other than drill. - Thanks, via mobile, excuse brevity. On Apr 14, 2016 10:10 PM, "soujanya metta" wrote: > HI, > We have the urgent requiremen

Re: Performance querying a single column out of a parquet file

2016-04-14 Thread Johannes Zillmann
Ok, thanks for the information! Am i right that in case DRILL-1950 would be fixed, Drill would automatically only materialize only those rows/columns which match the filter ? If not so, would the late materialization you described for the filter case be possible to implement with the current Ho

Question on querying parquet files

2016-04-14 Thread Johannes Zillmann
Hey there, 2 more questions on querying parquet files. (1) Cache files locally ? So far i tested Drill/Parquet only with a local file-system. If Drill loads a file from HDFS, how much of a overhead is that... Does it load the file from HDFS for the first query only and then keeps the file cache

Re: Performance querying a single column out of a parquet file

2016-04-14 Thread Ted Dunning
Not quite. With a fix for DRILL_1950, no rows would necessarily be materialized at all for the filter columns. Rows would only be materialized for the projection columns when the filter matches. In some cases, the pushdown might be implemented by fully materializing the values referenced by the f

Re: Question on querying parquet files

2016-04-14 Thread Jason Altekruse
Hi Johannes, Currently Drill does not implement any caching itself. Previously there have been discussions about general caching layers like Tachyon for caching reads of files from S3, but it looks like it should also be able to cache data from HDFS[1]. I do believe there was some discussion about

Drill 1.7 release date

2016-04-14 Thread Kumiko Yada
Hello, Is the Drill 1.7 going to be released this month? Thanks Kumiko