RE: Not able to create table in hive

Thanks Mark, I do have an access on metastore as I am login as admin. However when I query through Hue web interface it is working for me (using User: Guest). Here is how my hive-site.xml looks like. Is there any property that I need to extend here. javax.jdo.option.ConnectionURL jdbc

Re: Can you help with this error ...No privilege 'Create' found for outputs {.....

hi do you enable authorization ? hive> set hive.security.authorization.enabled; -- is this " true"? you can hive> set hive.security.authorization.enabled = false; or hive> grant create to your_username on table t1; 2012/2/3 Ronak Bhatt > hive> create table t1(t1 string); > > Authorization

Re: Can you help with this error ...No privilege 'Create' found for outputs {.....

Hi, set hive.security.authorization.enabled property false in hive-default.xml Thanks, Ankit On Fri, Feb 3, 2012 at 11:38 AM, Ronak Bhatt wrote: > hive> create table t1(t1 string); > > Authorization failed:No privilege 'Create' found for outputs { > database:test1}. Use show grant to get more

Can you help with this error ...No privilege 'Create' found for outputs {.....

hive> create table t1(t1 string); Authorization failed:No privilege 'Create' found for outputs { database:test1}. Use show grant to get more details. hive> * *

Re: UDF ;; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.FunctionTask

Those are pretty crappy instructions. Best to build jars with maven or ant or an iDE. On Thu, Feb 2, 2012 at 8:27 PM, Time Less wrote: > I sat down with one of our Java engineers who solved it. It actually > appears we're being affected by a slightly-incorrect set of instructions on > the intern

Re: UDF ;; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.FunctionTask

I sat down with one of our Java engineers who solved it. It actually appears we're being affected by a slightly-incorrect set of instructions on the internet. The typical web instructions (duplicated in many places on the web, such as here http://www.findnwrite.com/musings/extract-top-n-records-in-

Re: UDF ;; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.FunctionTask

Maybe you are being effected by this? https://issues.apache.org/jira/browse/HIVE-2635 On Thu, Feb 2, 2012 at 6:38 PM, Time Less wrote: > I'm having a heck of a time the past couple days. Google suggests others > have had this same error without resolution since mid-2010. Maybe someone > here

UDF ;; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.FunctionTask

I'm having a heck of a time the past couple days. Google suggests others have had this same error without resolution since mid-2010. Maybe someone here can shed some light on this? *See the package and method name: *[hdfs@laxhadoop1-012 15:23:14 ~/Tim] :) head LeoRank.java package com.riot.hive.ud

Re: How to check if all key/value pairs in two maps are equal?

Can you cast it into string and compare? On Thu, Feb 2, 2012 at 9:18 AM, Sunderlin, Mark wrote: > I am trying to see of two hive maps have the same data in them. I am > not looking to see if any single key-value pair in the maps match, I am > looking to see if > > **a)**There is a one

How to check if all key/value pairs in two maps are equal?

I am trying to see of two hive maps have the same data in them. I am not looking to see if any single key-value pair in the maps match, I am looking to see if a)There is a one to one match between the keys in map1 and the keys in map2 b) The matching keys have the same value in both map

Re: Table not creating in hive

Bhavesh     It is SQOOP related question hence moving to the SQOOP user group with hive user group in cc. Did you do your SQOOP import by specifying --hive-import ? If hive table creation still doesn't seem to work,execute the SQOOP command with --verbose and scan the logs to see what is happe

Re: Not able to create table in hive

Hi Manish, Sounds like a problem with your metastore. Can you verify that you have the access and correct permissions to your metastore? Mark Mark Grover, Business Intelligence Analyst OANDA Corporation www: oanda.com www: fxtrade.com e: mgro...@oanda.com "Best Trading Platform" - World Fin

RE: Hive ODBC - Microsoft’s Involvement

>> Any reason you want to use a ODBC and not Thrift ? Hive supports the thrift >> protocol. There are thrift libraries for C# and you can easily integrate it >> into your project for direct access to HIVE via your C# code. ODBC opens Hive up for use through any number of Windows based SQL clien

Not able to create table in hive

Hi, I am trying to create a table in Hive using below DDL: CREATE TABLE pokes (foo INT, bar STRING); I am getting below error, I have logged in as admin user : FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Cannot get a connection, pool error Could not create a validated obje

Re: Important Question

Hi Dalia     A sample DDL would be something like this. CREATE EXTERNAL TABLE employee(key string,no string,name string,address map)   STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,no:NUM,name:FIRST,address:") TBLPROPERTIES("

Table not creating in hive

Hello all, After successfully importing the tables in hive I am not able to see the table in Hive. When I imported the table I saw the dir on HDFS (under /user/hive/warehouse/) but when I execute command in Hive "SHOW TABLES" the table is not in the list. I find a lot about it but not getting any

RE: Important Question

Hiii Bejoy, Can you provide me with a simple example of how to mount Hbase table into a Hive Table ?? Thanks, Date: Wed, 25 Jan 2012 08:58:26 -0800 From: bejoy...@yahoo.com Subject: Re: Important Question To: user@hive.apache.org; u...@hbase.apache.org Hi DaliaBy complex queries if you are

setup default value of column in select statement

Does Hive support it? In mysql, we use select 12345 as c1, how can I do that it in Hive? Thanks a lot. -- Wei Yao Engineer of PapayaMobile inc. yao...@papayamobile.com +86-13811797327