Thank you so much! it really works!  java -Djavax.security.auth.useSubjectCredsOnly=false -jar <my jar name> ... View more

i don't think that hive does pruning on the table at left side during join, even if you provide the predicate in ON clause. That works in sql but not in hive. i am using hive 1.2. you can check this fact by using "explain <query>" . it is better to have the table pruned using sub query , and then join it with another table. let me know your thoughts. ... View more