Re: unbalanced transaction calls

2013-02-22 Thread Navis류승우
Could you try to make transaction related methods synchronized? It's openTransaction/commitTransaction/isActiveTransaction/rollbackTransaction on ObjectStore.java 2013/2/22 Hemanth Yamijala yhema...@gmail.com: Hi, We are running into the same problem as well. Is there any clue what could be

Re: Security for Hive

2013-02-22 Thread Jagat Singh
You might want to read this https://cwiki.apache.org/Hive/languagemanual-auth.html On Fri, Feb 22, 2013 at 9:44 PM, Sachin Sudarshana sachin.sudarsh...@gmail.com wrote: Hi, I have just started learning about hive. I have configured Hive to use mysql as the metastore instead of derby. If

Re: Security for Hive

2013-02-22 Thread Sachin Sudarshana
Hi, I have read about roles, user privileges, group privileges etc. But these roles can be created by any user for any database/table. I would like to know if there is a specific 'administrator' for hive who can log on with his credentials and is the only one entitled to create roles, grant

Re: unbalanced transaction calls

2013-02-22 Thread Hemanth Yamijala
Hi, This error is coming when we are running a CREATE TABLE script. Where are you suggesting we make these changes ? On Fri, Feb 22, 2013 at 1:31 PM, Navis류승우 navis@nexr.com wrote: Could you try to make transaction related methods synchronized? It's

Re: Security for Hive

2013-02-22 Thread bejoy_ks
Hi Sachin Currently there is no such admin user concept in hive. Regards Bejoy KS Sent from remote device, Please excuse typos -Original Message- From: Sachin Sudarshana sachin.sudarsh...@gmail.com Date: Fri, 22 Feb 2013 16:40:49 To: user@hive.apache.org Reply-To:

Re: unbalanced transaction calls

2013-02-22 Thread Vinod Kumar Vavilapalli
If we can enable access logs on the meta store and figure out the last query before the one that failed, it should be easy to track it. I did find a couple of unbalanced calls in code. Will look more carefully and file a ticket. Thanks, +Vinod Kumar Vavilapalli Hortonworks Inc.

Re: [SQLWindowing] Windowing function output path syntax (#26)

2013-02-22 Thread Butani, Harish
Hi Neelesh, You are using the syntax from the SQLWindowing project; which was done on top of HQL. Now the syntax is standard SQL; see ptf_general_queries.q for examples. Your e.g can be expressed as: select sum(tamt) over (partition by mid order by mid rows between unbounded preceding and

Re: [SQLWindowing] Windowing function output path syntax (#26)

2013-02-22 Thread neelesh gadhia
Thanks Harish for your quick response. I tried it with the new syntax using one of the example in ptf_general_queries.q and get the following error. Am I still doing something wrong here? hive select mid, tdate, tamt,sum(tamt) as com_sum over (rows between unbounded preceding and current row)

Function definition in hive

2013-02-22 Thread Yu PENG
Hi, I am a newbie for Hive. I was assigned a job to do a lot of queries with similar structure. I just want to ask if there is a way to define functions like other programming languages so that I can call the function with different parameters. This will be really helpful. Does anyone know that?

Re: Function definition in hive

2013-02-22 Thread Alexander Pivovarov
https://cwiki.apache.org/Hive/hiveplugins.html Creating Custom UDFs First, you need to create a new class that extends UDF, with one or more methods named evaluate. package com.example.hive.udf; import org.apache.hadoop.hive.ql.exec.UDF;import org.apache.hadoop.io.Text; public final class Lower

Re: [SQLWindowing] Windowing function output path syntax (#26)

2013-02-22 Thread Butani, Harish
The plan dump indicates that you are not using the latest code from the ptf-windowing branch. So first of all, if you can please try with the latest code. Otherwise can you post the log file of the failed task; and also tell us which version of the code you are using. Regards, Harish. From:

RE: Security for Hive

2013-02-22 Thread Austin Chungath
So that means any user can revoke or give permissions to any user for any table in the metastore? Sent from my Phone, please ignore typos -- From: bejoy...@yahoo.com Sent: 22-02-2013 11:30 PM To: user@hive.apache.org Subject: Re: Security for Hive Hi Sachin