Re: Give Custom Username to Hive Output Files

2012-12-11 Thread Nitin Pawar
you will need to use kerbrose based authentications for the same. that way you will have authentication and clear ownership defined as well On Wed, Dec 12, 2012 at 10:10 AM, Saurabh Mishra < saurabhmishra.i...@outlook.com> wrote: > Hi, > > When i try to insert some data into a hive table mappe

Give Custom Username to Hive Output Files

2012-12-11 Thread Saurabh Mishra
Hi, When i try to insert some data into a hive table mapped to a specific location in the HDFS, the file which gets created has user information as 'hive' and permissions as '755' i.e 'rwxr-xr-x' Is there any way to change this so that i can give my own usename or atleast the user from where i h

RE: Drop table in hive throws metastore excetion.

2012-12-11 Thread Hezhiqiang (Ransom)
Hi Anandha Because you set datanucleus.autoCreateTables=false. So hive would not create table automatic. When Hive drop table , index table will also be droped. So it will used INDEX_PARAMS table. I think you can try this.: 1、 set datanucleus.autoCreateTables=true 2、

Re: Map side join

2012-12-11 Thread Souvik Banerjee
Hello Everybody, Need help in for on HIVE join. As we were talking about the Map side join I tried that. I set the flag set hive.auto.convert.join=true; I saw Hive converts the same to map join while launching the job. But the problem is that none of the map job progresses in my case. I made the

Array index support non-constant expresssion

2012-12-11 Thread java8964 java8964
Hi, In our project to use the HIVE on CDH3U4 release (Hive 0.7.1), I have a hive table like the following: Table foo ( search_results array> search_clicks array>) As you can see, the 2nd column, which represents the list of search results clicked, contains the index location of which result

Hive Thrift upgrade to 0.9.0

2012-12-11 Thread Shangzhong zhu
We are using Hive 0.9.0, and we have seen frequent Thrift Metastore timeout issues probably due to the Thrift memory leak reported in THRIFT-1468. The current solution is to upgrade Thrift to 0.9.0 I am trying to use the patch (HIVE-2715). But seems the patch only works for Hive trunk (0.10.0). S

Creating external table poiting to s3 folder with files not loading data

2012-12-11 Thread Fernando Andrés Doglio Turissini
Long subject, I know.. let me explain a bit more about the problem: I'm trying to load a file into a hive table (this is on an EMR instance) for that I create an external table, and I set the location to the folder on an s3 bucket, where the file resides. The problem is that even though the table