Re: Deleting empty rows from hive table through java

If data is not huge then please export it into csv. You have to do all the transformation on csv and point your table on it. Would you mind telling me how you are loading your data in hive. Regards, Vikas Parashar On Tue, Jan 5, 2016 at 1:46 PM, Sateesh Karuturi < sateesh.karutu...@gmail.

Re: Deleting empty rows from hive table through java

What is the backend of your table? Is it csv, orc or anything else! Regards, Vikas Parashar On Tue, Jan 5, 2016 at 12:28 PM, Sateesh Karuturi < sateesh.karutu...@gmail.com> wrote: > Hello... > Anyone please help me how to delete empty rows from hive table through > java? > Thanks in advance >

Re: Deleting empty rows from hive table through java

Well said Mich, I had gone through from the same scenario in which we had done ETL out side the hive. Once the transformation is done then we loaded all data into hive warehouse. I think, that's the best practice, we should follow it. Regards, Vikas Parashar On Tue, Jan 5, 2016 at 5:02 PM, Mich

Re: Double quotes in csv data

Hi Micheal, You can write some python/perl script and can transform the csv. On Wed, Oct 21, 2015 at 8:57 PM, wrote: > Hi, > > > > I have some CSV data which is encompassing each field in double quotes > e.g. “hello”, “”, “test”, “”. > > > > I noticed that there

Re: Repeated Hive start-up issues

Hi Anand, That depends on issue. You have to understand namenode logs. Sent from really tiny device :) On Friday, May 15, 2015, Anand Murali anand_vi...@yahoo.com wrote: Hi: Many thanks for replying. Can you please tell me how to fix namenode safe mode issue. I am new to Hadoop.

full query submitted to hiveserver2

Hi, I have written an application that is contacting with my hive server2. I just want to check how may queries has been submitted on my hive and full details about the query. But when i have grep this remote command in my hiveserver2 logs. I got below information only: [abc@xyz ~]# cat

Re: Beeline client

. Probably this is an issue in beeline cli. If anyone know please let me know how to move right side on beeline cli ?? On Sat, Nov 1, 2014 at 10:07 AM, Vikas Parashar para.vi...@gmail.com wrote: you can use shift+page up/down. On Sat, Nov 1, 2014 at 9:45 AM, Hanish Bansal

Re: Beeline client

Are you using CLI ? On Sat, Nov 1, 2014 at 12:33 AM, Hanish Bansal hanish.bansal.agar...@gmail.com wrote: Hi, I am using Beeline client to connect to hiveserver2 on linux machine. In terminal when i run query: select * from table; It only show first few columns in case there is large

Re: Beeline client

you can use shift+page up/down. On Sat, Nov 1, 2014 at 9:45 AM, Hanish Bansal hanish.bansal.agar...@gmail.com wrote: Yeah beeline cli. On Sat, Nov 1, 2014 at 12:37 AM, Vikas Parashar para.vi...@gmail.com wrote: Are you using CLI ? On Sat, Nov 1, 2014 at 12:33 AM, Hanish Bansal

Re: One information about the Hive

-- *From:* Vikas Parashar [para.vi...@gmail.com] *Sent:* Sunday, January 12, 2014 10:50 PM *To:* Prashant Kumar - ERS, HCL Tech *Cc:* user@hive.apache.org *Subject:* Re: One information about the Hive Prashant, Actually I just started reading and understanding the Hive. Could you

Re: One information about the Hive

Prashant, I am new to Hive, I am reading the doc which is available on Apache site and try to create a correlation between hadoop and Hive. so please help me to understand this: As per my understanding, all the files where unstructured data are stored in HDFS system across the hadoop

Re: One information about the Hive

to some known member of Big Data. Note: One imp thing, can I post the question directly to you, if you do not mind and if I am not disturbing you. Please put all question's on community only. Thanks Prashant *From:* Vikas Parashar [mailto:para.vi...@gmail.com] *Sent:* Monday

Re: hive hbase integration

htrace-core-2.01.jar hbase-client-0.96.0.2.0.6.0-76-hadoop2.jar hbase-server-0.96.0.2.0.6.0-76-hadoop2.jar zookeeper-3.4.5.2.0.6.0-76.jar hbase-common-0.96.0.2.0.6.0-76-hadoop2.jar hive-hbase-handler-0.12.0.2.0.6.0-76.jar On Thu, Dec 26, 2013 at 10:38 PM, Vikas Parashar para.vi

Re: hive hbase integration

have had some issues in the past doing so. The post here[1] has some solutions on how to configure hive ot work with yarn. Hope that helps. [1] https://groups.google.com/a/cloudera.org/forum/#!topic/cdh-user/gHVq9C5H6RE On Thu, Dec 26, 2013 at 10:35 AM, Vikas Parashar para.vi