Re: Need urgent help

This copy was successful. The file was not corrupted Sent from Samsung Mobile Original message From: Andre Araujo Date:01/07/2014 23:45 (GMT-08:00) To: user Subject: Re: Need urgent help Can you try the following to check if there's any problem with the jar itself? hadoop fs

Re: Need urgent help

Can you try the following to check if there's any problem with the jar itself? hadoop fs -copyToLocal hdfs://xx.xx.xx.xxx:9000/user/ipg_intg_user/AP/scripts/lib/wsaUtils.jar /tmp/ hive> add jar file:///tmp/wsaUtils.jar; On 2 July 2014 16:01, wrote: > -rw-r--r-T 1 ipg_intg_user supergroup

RE: Need urgent help

-rw-r--r-T 1 ipg_intg_user supergroup 621942 2014-05-20 21:33 hdfs://xx.xx.xx.xxx:9000/user/ipg_intg_user/AP/scripts/lib/wsaUtils.jar From: Andre Araujo [mailto:ara...@pythian.com] Sent: Tuesday, July 01, 2014 10:46 PM To: user Subject: Re: Need urgent help What's the result of the command

Re: Skewed vs ListBucketing

The Skewed Tables section in the DDL wikidoc has more information which might be helpful. HIVE-3649 was just one of several jiras that added list bucketing in releases 0.10 and 0.11. See HIVE-3026

Re: Need urgent help

What's the result of the command below? hadoop fs -ls hdfs://xx.xx.xx.xxx:9000/user/ipg_intg_user/AP/scripts/lib/wsaUtils.jar On 2 July 2014 14:07, wrote: > Can you please elaborate on the permission > > > > > > Hi, > > Cannot add a jar to hive classpath. > > Once I launch HIVE, I type -> ADD

Re: Need urgent help

Yes Sent from Samsung Mobile Original message From: Abirami V Date:01/07/2014 22:15 (GMT-08:00) To: user@hive.apache.org Subject: Re: Need urgent help Hi, have you add the property in hive( hive.aux.jars.path. The location of the plugin jars that contain implementations o

Re: Skewed vs ListBucketing

Does anyone have time to answer this? It would be good to clarify things in the wiki. HIVE-3649 added the list bucketing feature in release 0.10.0. The description says: We need to differ normal skewed table from list bucketing table. we use an

Re: Error in adding Hive UDF

Just export that path in your class path and restart megastore service. On Jun 27, 2014 7:26 PM, "Rishabh Bhardwaj" wrote: > Hi all, > I have a udf namely gwudf.jar > I have it on my local dir at /tmp/gwudf.jar ,and > also at hdfs at /user/hive/lib/gwudf.jar > > so when I am adding this jar, The

Re: Need urgent help

Hi, have you add the property in hive( hive.aux.jars.path. The location of the plugin jars that contain implementations of user defined functions and serdes.) https://cwiki.apache.org/confluence/display/Hive/AdminManual+Configuration Thanks, Abirami On Tue, Jul 1, 2014 at 9:56 PM, hadoop hiv

RE: Need urgent help

Are you able to see the file after giving full path like Hadoop fs -ls hdfs://$lpath:9000/pathToJar On Jul 2, 2014 10:17 AM, wrote: > The user has read permission > > Its > > rw-r—r— > > Thanks, > > Shouvanik > > > > *From:* hadoop hive [mailto:hadooph...@gmail.com] > *Sent:* Tuesday, July 01,

Re: ERROR 1115: Unsupported type: 5 in Pig's schema

Did you checked your .CSV file it must have same no of column. Scema looks good. On Jun 30, 2014 7:37 PM, "Carlotta Hicks" wrote: > Hi All! I created an hbase table and hcatalog table like the following: > > > > > > hive> describe formatted client; > > OK > > # col_name

RE: Need urgent help

The user has read permission Its rw-r—r— Thanks, Shouvanik From: hadoop hive [mailto:hadooph...@gmail.com] Sent: Tuesday, July 01, 2014 9:45 PM To: user@hive.apache.org Subject: RE: Need urgent help Jar must have read permission by that user. Which you are using to run the jobs. On Jul 2, 2014 9

Re: Column selection in Hive

Here's the wikidoc for dropping columns with ALTER TABLE ... REPLACE COLUMNS: Add/Replace Columns . But you'd still have to list 190 columns, so CTAS would be more direct. AFAIK, HiveQL doesn

RE: Need urgent help

Jar must have read permission by that user. Which you are using to run the jobs. On Jul 2, 2014 9:37 AM, wrote: > Can you please elaborate on the permission > > > > > > Hi, > > Cannot add a jar to hive classpath. > > Once I launch HIVE, I type -> ADD JAR > hdfs://xx.xx.xx.xxx:9000/user/ipg_intg_

RE: Need urgent help

Can you please elaborate on the permission Hi, Cannot add a jar to hive classpath. Once I launch HIVE, I type -> ADD JAR hdfs://xx.xx.xx.xxx:9000/user/ipg_intg_user/AP/scripts/lib/wsaUtils.jar; I get the error, Failed to read external resource hdfs://xx.xx.xx.xxx:9000/user/ipg_intg_user/AP/scr

Recall: Need urgent help

Haldar, Shouvanik would like to recall the message, "Need urgent help". This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender i

Recall: Need urgent help

Haldar, Shouvanik would like to recall the message, "Need urgent help". This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender i

Re: Need urgent help

Hi, Is the user which is running query having rights to access the file. Thanks On Wed, Jul 2, 2014 at 1:51 PM, wrote: > Hi, > > Cannot add a jar to hive classpath. > > Once I launch HIVE, I type -> ADD JAR hdfs://10.37.83.117 > :9000/user/ipg_intg_user/AP/scripts/lib/wsaUtils.jar; > > > > I

Re: Need urgent help

Check the permission and validate if jar is not corrupted. Apart from that you can put this jar inside in hive lib directory, that will be automatically read by hive. Thanks Vikas Srivastava On Jul 2, 2014 9:21 AM, wrote: > Hi, > > Cannot add a jar to hive classpath. > > Once I launch HIVE, I

Need urgent help

Hi, Cannot add a jar to hive classpath. Once I launch HIVE, I type -> ADD JAR hdfs://10.37.83.117:9000/user/ipg_intg_user/AP/scripts/lib/wsaUtils.jar; I get the error, Failed to read external resource hdfs://10.37.83.117:9000/user/ipg_intg_user/AP/scripts/lib/wsaUtils.jar Query returned non-zero

Re: Hive Query (Replace)

I'm no expert, but could you use the regexp_replace or translate function? >From the Hive wiki : regexp_replace(string INITIAL_STRING, string PATTERN, string REPLACEMENT) > > Returns the string

Hive Query (Replace)

Hi Everyone, Is there a way to ignore a particular character in hive query. Example Table1 Field name: empName Value : xx! Is there a way to remove '!' cause this prevents some join operations with another table containing the exact same values other than this column with a '!' in its value

Re: Column selection in Hive

Hi, A workaround could be to create a table with all the columns and then drop the columns you don't need. Hope it helps. Regards, Sarfraz Rasheed Ramay (DIT) Dublin, Ireland. On Tue, Jul 1, 2014 at 5:20 AM, Szehon Ho wrote: > Why dont you just use CTAS (Create table as select), putting the 1

Re: Multiple insert on same table with INSERT OVERWRITE + INSERT INTO ?

After doing some simple tests, multiple insert into the same partition of the same table is disallowed by hive, except when using dynamic partitioning... In that specific case, I don't know if the behavior should be considered as an undefined behavior, a feature or a bug... What do you think?

Re: Alter location of database in Hive

Hello If you do alter location 'new-location' in your all tables it does not work ? Le 1 juil. 2014 03:15, "Prem Yadav" a écrit : > I think you should be able to copy the data to a different location and > then drop the old db, and create a new one with the new location. > > > On Tue, Jul 1, 2014