Re: Custom UserDefinedFunction in Hive

2012-08-07 Thread Raihan Jamal
it for sure? *Raihan Jamal* On Mon, Aug 6, 2012 at 10:56 PM, Jan Dolinár dolik@gmail.com wrote: Hi Jamal, Check if the function really returns what it should and that your data are really in MMdd format. You can do this by simple query like this: SELECT dt, yesterdaydate

Re: Custom UserDefinedFunction in Hive

2012-08-07 Thread Raihan Jamal
10; So that means it will look for data in the corresponding dt partition *(20120806) *only right as above table is partitioned on dt column ? And it will not scan the whole table right?** *Raihan Jamal* On Mon, Aug 6, 2012 at 10:56 PM, Jan Dolinár dolik@gmail.com wrote: Hi Jamal

Re: Custom UserDefinedFunction in Hive

2012-08-07 Thread Raihan Jamal
is- How to get the Yesterdays date which I can use on the Date Partition I cannot use hiveconf here as I am working with Hive 0.6 *Raihan Jamal* On Tue, Aug 7, 2012 at 10:37 AM, Jan Dolinár dolik@gmail.com wrote: I'm afraid that he query SELECT * FROM REALTIME where dt

[jira] [Updated] (HIVE-3233) Error in semantic analysis:Invalid Table Alias

2012-08-06 Thread Raihan Jamal (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3233?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raihan Jamal updated HIVE-3233: --- Priority: Major (was: Minor) Error in semantic analysis:Invalid Table Alias

Custom UserDefinedFunction in Hive

2012-08-06 Thread Raihan Jamal
*Problem* I created the below UserDefinedFunction to get the yesterday's day in the format I wanted as I will be passing the format into this below method from the query. *public final class YesterdayDate extends UDF {* * * *public String evaluate(final String format) { * *

Variable Substitution in Hive 0.6?

2012-08-04 Thread Raihan Jamal
Does anyone is aware of Hive variable substitution works in Hive 0.6 or not? *Raihan Jamal*

[jira] [Created] (HIVE-3233) Error in semantic analysis:Invalid Table Alias

2012-07-05 Thread Raihan Jamal (JIRA)
Raihan Jamal created HIVE-3233: -- Summary: Error in semantic analysis:Invalid Table Alias Key: HIVE-3233 URL: https://issues.apache.org/jira/browse/HIVE-3233 Project: Hive Issue Type: Bug

Connect Squirrel SQL Client to access Hive tables

2012-07-01 Thread Raihan Jamal
is, as I am using this hostname `ares-ingest.vip.name.com` to log into Putty. I am hoping the question is clear. Any suggestion will be appreciated. **In short my question is- Can I do the same thing in any SQLClient instead of logging from the Putty?** -Raihan Jamal

Connect Squirrel SQL Client to access Hive tables

2012-07-01 Thread Raihan Jamal
is, as I am using this hostname `ares-ingest.vip.name.com` to log into Putty. I am hoping the question is clear. Any suggestion will be appreciated. **In short my question is- Can I do the same thing in any SQLClient instead of logging from the Putty?** -Raihan Jamal