Re: [Error] : while registering Hbase table with hive

Hi Divya, Can you paste the Hive table structure as well as HBASE table structure? Regards, Swagatika On Mon, Feb 29, 2016 at 8:51 AM, Divya Gehlot wrote: > Hi, > I trying to register a hbase table with hive and getting following error : > > Error while processing

Re: Cannot convert column 2 from string to map<string,string> error

Hi Buntu, Since the attribute attrs is of type MAP,So, you need to do it something like: insert into tmp_table values ( 'src1', 'uid1',map("NULL","NULL"). Let me know if it works. On Tue, Mar 1, 2016 at 5:06 AM, Buntu Dev wrote: > When attempting to insert null value

Re: Fwd: Row exception in Hive while using join

Hi Krish, It seems the data corresponding to that particular row pertaining to key 12 is corrupt.Can u try reloading the data and then selecting? Let me know if it works. Regards Swagatika On Mar 5, 2015 4:45 PM, krish kri22go...@gmail.com wrote: I got the following exception while executing

Re: Re: How to query data by page in Hive?

Hello Debopam Please mail.me the queries as well for rank/dense rank. TIA. Regards Swagatika On Feb 5, 2015 3:51 PM, Devopam Mittra devo...@gmail.com wrote: Please provide a valid table structure and the columns you wish to pick and I shall email you the query directly regards Devopam On

Re: how to load json with nested array into hive?

Hi, Use 1.9.3 Jason serde with dependencies jar. Its the latest one I suppose. Thanks Swagatika On Jun 23, 2014 11:57 PM, Roberto Congiu roberto.con...@openx.com wrote: Hi, 1.1.4 is a oldish version of the JSON serde, have you tried with the most recent from the master branch ? On Mon, Jun

Re: Executing Hive Queries in Parallel

Hi, You can also use oozie's fork fearure which acts as a workflow scheduler to run jobs in parallel. You just need to define all our hql's inside the workflow.XML to make it run in parallel. On Apr 22, 2014 3:14 AM, Subramanian, Sanjay (HQP) sanjay.subraman...@roberthalf.com wrote: Hey

Re: READING FILE FROM MONGO DB

Do we hv a for loop concept in hive to iterate through the array elements n display them. We need an alternative for explode method Well you cN use Json serde for this Sent from my iPhone On Mar 26, 2014, at 8:40 PM, Swagatika Tripathy swagatikat...@gmail.com wrote: Hi , The use case is we have

READING FILE FROM MONGO DB

Hi, We have some files stored in MongoDB , mostly in key value format. We need to parse those files and store it into Hive tables. Any inputs on this will be appreciated. Thanks, Swagatika

Re: READING FILE FROM MONGO DB

26, 2014 at 10:01 AM, Nitin Pawar nitinpawar...@gmail.comwrote: take a look at https://github.com/yc-huang/Hive-mongo On Wed, Mar 26, 2014 at 10:29 PM, Swagatika Tripathy swagatikat...@gmail.com wrote: Hi, We have some files stored in MongoDB , mostly in key value format. We need to parse

Deleting a column from internally managed table

Yes; u can do so... 5 individual alter table replace column command will do On 1/9/14, Kishore kumar kish...@techdigita.in wrote: No I want to change 4to5 columns only outof 40 columns. On Wed, Jan 8, 2014 at 2:05 PM, Edward Capriolo edlinuxg...@gmail.comwrote: Alter table replace columns

SET PROPERTY FOR UDF

Hi, I want to customize the hive-site.xml to add some extra properties to be used for a UDF. The UDF is a part of the view to be created. So , i tried setting the path through hivecli as below: set hive.property.path=/Users/path of hive-testing.xml; but it does not seem to take the path and

Re: load data stored as sequencefiles

Make sure you have set the table properties while creating the table structure. Also , it should not be a problem unless it is a FixedLength.Try altering the table to set it to the type desired or else it will be by default SequenceFile On Tue, Sep 24, 2013 at 7:51 PM, Artem Ervits

Re: UDAF HELP

16, 2013 at 11:43 PM, Swagatika Tripathy swagatikat...@gmail.com wrote: Hi, i have a requirement to compare two different columns in 2 adjacent rows and if values are equal, it should return a non zero value else should give 0 as result. Please let me know how can we implement using UDAF(User