Apache kudu

[#1]

I have a kudu table with more than a million records, i have been asked to do some query performance test through both impala-shell and also java. Through impala-shell i am able to perform all the queries and it gives me the timestamp through which i get to know the time taken for running the query,but whne it comes to perfrom queries using java api kudu,is it possible if i can perform join query operation using java api kudu and benchmark the logs

[#2 · Accepted solution]

Hi HJ,

It is not possible to do a join using the native Kudu NoSQL API. You will need to use SQL with Impala or Spark SQL, or using the Spark data frame APIs to do the join.

Mike

[#3 · Accepted solution]

The only way I know of to do complex queries through Java is to use the Impala JDBC connector, which you can find here: https://www.cloudera.com/downloads/connectors/impala/jdbc/2-6-3.html

[#4]

However I see you wrote a separate forum post which is good, we try to stick with one topic per thread in the forums.

[#5]

thank you again for the solution.I found a java code which loads data into kudu table from csv. is it efficient.?