Re: Question about partition pruning when there's a type mismatch

2016-11-29 Thread Anthony Hsu
Thanks for the tips, Gopal. I stepped through the code in a debugger and found that in the case of String = String, the predicate was pushed down to the SQL query on the metastore side, whereas in the case of String = Int, the SQL filter pushdown failed, so GenericUDFOPEqual gets evaluated and

Question about partition pruning when there's a type mismatch

2016-11-28 Thread Anthony Hsu
Hi, Some of our Hive tables are partitioned on a STRING column "datepartition" whose format is "-mm-dd-hh". Usually, when users want to read only a specific day of data, they'll specify WHERE datepartition = '2016-11-28-00', for example. However, sometimes users accidentally forget the quotes

Is the Hive PreCommit Build broken?

2014-04-15 Thread Anthony Hsu
Hi, Yesterday, I uploaded a new patch to HIVE-6835https://issues.apache.org/jira/browse/HIVE-6835, and it's been over 24 hours and I haven't gotten the pre-commit build results. Looking at http://bigtop01.cloudera.org:8080/view/All/job/PreCommit-HIVE-Build/lastBuild/?, it seems like the last

RE: FAILED: SemanticException [Error 10001]: Table not found answer

2014-04-01 Thread Anthony Hsu
Hi Rishabh, You can get more logging info, including the full stack trace, by changing the logging level when starting Hive: hive -hiveconf hive.root.logger=INFO,console Cheers, Anthony From: Rishabh Bhardwaj [rbnex...@yahoo.com] Sent: Monday, March 31, 2014

Request for Write Access to Hive Wiki

2014-03-31 Thread Anthony Hsu
Hi, Could somebody grant me write access to the Hive wiki? I'd like to update some outdated information on the Hive Tutorialhttps://cwiki.apache.org/confluence/display/Hive/Tutorial page. My Apache Confluence username is erwaman. Cheers, Anthony