About kumarvaibhav199

kumarvaibhav199 · ‎11-03-2016

This Problem has been solved.THere was an extra space between my_var1and $Var.

kumarvaibhav199 · ‎11-03-2016

Hi All, I have something like Myarray.sh hive -S -hiveconf MY_VAR1 =$Var -f /home/vaibhav/Desktop/my_script.hql Where $Var is the name of the file coming from an array from the shell script .the above line is also defined in that shell script only. My_Script.hql loAD DATA LOCAL INPATH '/home/vaibhav/Desktop/'${hiveconf:MY_VAR1}' ' OVERWRITE INTO TABLE xyz When i'm trying to execute the above scenerio i'm getting error like : FAILED: SemanticException Line 1:23 Invalid path ''/home/vaibhav/Desktop/=mydata.csv'': No files matching path file:/home /vaibhav/Desktop/=mydata.csv

kumarvaibhav199 · ‎10-08-2016

I'm not sure about my data because here even composite keys can produce duplicates. so going by analytical function is not a good choice for me.Any how query is not taking that much time for me. I voted up for your Solution .Thanks For your Response. 🙂 @Constantin Stanca

kumarvaibhav199 · ‎10-07-2016

@Constantin Stanca yes it will not work in case in duplicates but in case of distinct values the below worked: select a.id,b.id from analytical a inner join (select id from analytical order by id desc limit 3) b on a.id=b.id ORDER BY A.ID ASC LIMIT 1

kumarvaibhav199 · ‎10-06-2016

@prasoon kumar with Doesn't work in hive

kumarvaibhav199 · ‎10-06-2016

1. i think An inner join between the same table twice with limit 1 will solve this issue . 2 . I cannot go with rownumber as you can see i have duplicate column values which will not give me correct results @mqureshi

kumarvaibhav199 · ‎10-05-2016

HI, I have 5 records in my database and i want to select the 3rd records.Minus is not possible in hive.So i'm trying Left outer join to perform the query.It's giving me some random results. Id,Codes 1 100 1 200 2 200 3 200 3 300 select a.id,b.id from analytical a inner join (select id from analytical order by id desc limit 2) b on a.id=b.id where b.id is null order by a.id asc limit 3 OUtput: id,codes 1 NULL 1 NULL 2 NULL ANy suggestions?

kumarvaibhav199 · ‎10-03-2016

Can anybody provide a solution?

kumarvaibhav199 · ‎10-03-2016

Hi I have some scenerio like below in hive .i'm unable to find a solution for the below problem. Input: ID ,CODE 1,ABCD 2,BCDE 2,ERTY 1,ZZZZ 3,GHEF Output: ID ,CODE 1, ABCDZZZZ ->Concatination of the code for the same ID. 2 BCDEERTY 3 GHEF I can have a static work around here where i can just aggregate the values and use them accordingly but the thing is i don't know how many reason codes i'm going to get from my source it could be thousand or more . I have going through the link http://stackoverflow.com/questions/23025380/how-to-transpose-pivot-data-in-hive but it's all static .here static means just know the values a,b,c,d and then doing the aggreagte for only those values but what about nth of any incoming value.

kumarvaibhav199 · ‎08-22-2016

@Artem Ervits @Arun A K Thank you so much for giving your time to solve the problem!!! Kudos The problem got solved ,actually i was not having 777 Permissions on whatever was there on desktop ,so i followed the following steps: $sudo chmod -R 777 /home/vaibhav/Desktop Then format namenode ( Only if this does not harm you anyway) and re-start your daemons and followed the same steps to store the data and the directory got created on dektop.

Online	Offline
Last Visited	‎01-07-2019 11:10 AM

Member Since	‎07-19-2016 06:01 PM
Last Visited	‎01-07-2019 11:10 AM
Posts	88
Kudos received	13

Cloudera Community

Re: Load Hive table using Hiveconf Variable

Re: PIG Store Command not working in local mode

Re: Load Hive table using Hiveconf Variable

Load Hive table using Hiveconf Variable

Re: Select nth row in hive

Re: Select nth row in hive

Re: Select nth row in hive

Re: Select nth row in hive

Select nth row in hive

Re: Dynamic transpose of rows to columns

Dynamic transpose of rows to columns

Re: PIG Store Command not working in local mode