Re: Executing queries on rows from multiple tables

2012-02-13 Thread Sameer Agarwal
Thanks! On 13 February 2012 19:45, Roberto Congiu wrote: > You can use UNION even if the tables are different: > SELECT * > FROM ( > select_statement > UNION ALL > select_statement > ) unionResult > > > https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Union > > On Mon, Feb 13,

RE: Initializing a custom UDF

2012-02-13 Thread Parimi, Nagender
Per the UDF definition at http://hive.apache.org/docs/r0.7.0/api/org/apache/hadoop/hive/ql/exec/UDF.html, I could potentially pass the configuration (e.g. path to configuration file) as another argument to evaluate(). I could load the configuration on the first call to evaluate() into a singlet

Re: Executing queries on rows from multiple tables

2012-02-13 Thread Roberto Congiu
You can use UNION even if the tables are different: SELECT * FROM ( select_statement UNION ALL select_statement ) unionResult https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Union On Mon, Feb 13, 2012 at 7:10 PM, Sameer Agarwal wrote: > Hi, > > Is there a straightforward w

Executing queries on rows from multiple tables

2012-02-13 Thread Sameer Agarwal
Hi, Is there a straightforward way to execute a query on rows from multiple tables in Hive? Specifically, let's say that we have 2 tables A and B with exactly the same schema. Is it possible for me to execute a query on all the rows of A and B? If not, what could be the best way to alter the table

Re: Initializing a custom UDF

2012-02-13 Thread wd
An UDF can accept some params, you can pass your configuration in one of it? On Tue, Feb 14, 2012 at 10:02 AM, Parimi, Nagender wrote: > Hi, > > > > Is there a way to pass in some custom arguments to a UDF when initializing > it? I’d like to pass in some configuration parameters to a UDF, but did

Initializing a custom UDF

2012-02-13 Thread Parimi, Nagender
Hi, Is there a way to pass in some custom arguments to a UDF when initializing it? I'd like to pass in some configuration parameters to a UDF, but didn't see a way to readily do so. thanks, Nagender

Re: How to do updation in Hive?

2012-02-13 Thread Mark Grover
Hi Bhavesh, I am no expert in this matter but typical Hive use cases don't involve updates. If your workflow, relies considerably on updating existing data in Hive (i.e. in HDFS), you might need to re-think your design or the tools you use. Mark Mark Grover, Business Intelligence Analyst OANDA

RE: NPE (INSERT OVERWRITE)

2012-02-13 Thread Brian.Richardson
I have spent a few days trying to get past what I feel is a trivial issue. Just trying to commit Hive mapReduce results to a Cassandra CF using the Hive overwrite table function. I have reviewed a few online examples and wrote my procedure a few different ways, always getting the same exception.

Re: HiveR

2012-02-13 Thread Jonathan Seidman
Are you actually referring to RHive: https://github.com/nexr/RHive/wiki? If so it looks like a very interesting project, but I haven't talked to anyone actually using it yet. If it looks like a good fit for your particular applications then the best thing would be to install and start working with

Re: query parameters in hive

2012-02-13 Thread Evan Pollan
Sure -- use -hiveconf X=Y, which allows your script to reference ${hiveconf:X} On Feb 13, 2012, at 7:19 AM, "Wojciech Langiewicz" wrote: > Hello, > Is it possible (and how) to pass parameters to hive scripts from command > line? > I would imagine something like: > hive -f xyz.sql -p date='2012

query parameters in hive

2012-02-13 Thread Wojciech Langiewicz
Hello, Is it possible (and how) to pass parameters to hive scripts from command line? I would imagine something like: hive -f xyz.sql -p date='2012-02-13' which will substitute any occurrence of $date string in xyz.sql file. I've searched wiki and list archive, but I didn't find any clues about

How to do updation in Hive?

2012-02-13 Thread Bhavesh Shah
Hello all, I want to update a columns every time. I have table consists of 50 columns. I am applying such condition so that every time I need to update a column. I know that Hive doesn't support UPDATE and If I think about using PARTITION COLUMN so how can I maintain these columns? Is there any w

Copenhagen / Scandinavian HUG Meetup - any interest?

2012-02-13 Thread Tim Robertson
Hi all, (cross posted to a few Hadoop mailing lists - apologies for the SPAM) Are there any users around the Copenhagen area that would like a HUG meetup? Just reply with +1 and I'll gauge interest. We could probably host a 1/2 or full day if people were coming from Sweden... We are using Hadoo