Re: Row Delimiter in Create table

f do that is setting > "textinputformat.record.delimiter" in table properties. > > Thanks, > Navis > > 2014-12-18 6:20 GMT+09:00 Gayathri Swaroop : >> >> Hi, >> >> I am trying to create table for a text file who has a row delimiter other >> than new line charac

Row Delimiter in Create table

Hi, I am trying to create table for a text file who has a row delimiter other than new line character. I know hive create table does not support anything other than new line. I have columns where in data contains new line so i specified a new line character in my sqoop. What are the best options a

Fwd: Case inside select statement in hive

I use hive 0.12.0. -- Forwarded message -- From: Gayathri Swaroop Date: Tue, Dec 16, 2014 at 10:37 AM Subject: Case inside select statement in hive To: user Hi, I have oracle query which i want to hit against a hive table. The oracle query has a case if exists select would this

Case inside select statement in hive

Hi, I have oracle query which i want to hit against a hive table. The oracle query has a case if exists select would this work in hive? This is my oracle query that needs to be converted to hive. select distinct CONTR.BMF_PARTNER_ID AS BMF_BMF_PARTNER_ID, CONTR.BUSINESS_PARTNER AS

Re: Question on varchar in 0.12.0 version of nive

> > I am a newbie to hive. I am trying to query an oracle table in hive. The > data is in hadoop and i have created similar varchar columns in my external > table. Would like to know what are the limitations of varchar over string. > And why people prefer string over varchar. > > Thanks, > Gayathri

Question on varchar in 0.12.0 version of nive

I am a newbie to hive. I am trying to query an oracle table in hive. The data is in hadoop and i have created similar varchar columns in my external table. Would like to know what are the limitations of varchar over string. And why people prefer string over varchar. Thanks, Gayathri