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,

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: Hive function to convert numeric IP address to "dot" format?

iveUDFs/blob/master/src/main/java/net/petrabarus/hiveudfs/LongToIP.java > > Share and enjoy! > > -- > Mark E. Sunderlin > Data Architect // Data Solutions > P: 703-265-6935 // C: 540-327-6222 // 22000 AOL Way, Dulles, VA 20166 > AIM: MESunderlin // Slack: @Mark.Sunderlin > &

Re: Hive function to convert numeric IP address to "dot" format?

Hi Mark, You can segregate it at the input level. Could you please explain how your data are ingesting in DB. On Fri, Oct 23, 2015 at 12:14 AM, Mark Sunderlin wrote: > Does hive have a built in function to return a dotted-quad representation > of an IP address given a network address as an int

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 is a CSV Serde now available

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 wrote: > Hi: > > Many thanks for replying. Can you please tell me how to fix namenode safe > mode issue. I am new to Hadoop. > > Thanks > > Regards >

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 /var/log/

Re: Beeline client

Late reply, but I saw a similar issue as described in HIVE-6928, which is >> fixed. Not sure if its the same issue. You can also try >> --outputFormat=vertical as a workaround. >> >> Thanks >> Szehon >> >> On Sat, Nov 1, 2014 at 12:03 AM, Vikas Parashar &

Re: Beeline client

umns on beeline cli depending on > length of column names. > > 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 > wrote: > >> you

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 > wrote: > >> Are you using CLI ? >> >> On Sat,

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

Re: One information about the Hive

MITED FIELDS TERMINATED BY ',' " > --> hive -e "select songname from songs where lastname='lennon' OR > lastname = 'harrison'" > > Hope this helps > > Hive on !!! > > sanjay > > > > > > >id,seq,

Re: One information about the Hive

n do, i just fwd your request 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 >

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: hive hbase integration

2.jar 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 wrote: >

Re: hive hbase integration

ad of mr1. I 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

hive hbase integration

Hi, I am integrating hive(0.12) with hbase(0.96). Everything is working fine there but get stuck between two quires. When i create table or select * from table then it's working fine . but in case of select count(*) from table it give me below error. 2013-12-26 13:25:01,864 ERROR ql.Driver (Ses