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 retu

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-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 las

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 11:5

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 Tutorial page. My Apache Confluence username is erwaman. Cheers, Anthony