Re: Permission denied: user=root, access=WRITE, inode="/user/root":hdfs:hdfs:drwxr-xr-x

2016-10-05 Thread Amrit Jangid
Hi Raj Do add root user into hdfs group. Run this command on your NameNode server. useradd -G hdfs root On Wed, Oct 5, 2016 at 2:07 PM, Raj hadoop wrote: > Im getting it when im trying to start hive > > hdpmaster001:~ # hive > WARNING: Use "yarn jar" to launch YARN applications. > > how can I

Hive table show less records than hbase

2016-06-06 Thread Amrit Jangid
Hi All, *Using HBase0.98.6, CDH5.3.5 and Hive-0.13.1* I am accessing a hbase table from Hive, all column are mapped as string type. if i do coun(*) from hive on table, i get less record than total records in hbase table. Also found this case - i have a coulmn -email type of string. hive> *s

Re: Hbase-Hive table integration Error

2016-03-01 Thread Amrit Jangid
Anyone ? On Fri, Feb 26, 2016 at 3:50 PM, Amrit Jangid wrote: > Hi , > > I wanted to access one hbase table in hive, during creating the table, had > incorrect columns mapping in query. > > Now i want to DROP the table to create it again.But every query(DESCRIBE , > DROP

Hbase-Hive table integration Error

2016-02-26 Thread Amrit Jangid
Hi , I wanted to access one hbase table in hive, during creating the table, had incorrect columns mapping in query. Now i want to DROP the table to create it again.But every query(DESCRIBE , DROP, SELECT) in table is giving error as : Error while compiling statement: FAILED: RuntimeException Me

Re: External table returns no result.

2016-02-21 Thread Amrit Jangid
Thanks, its worked .!! On Sat, Feb 20, 2016 at 8:18 PM, Divya Gehlot wrote: > Yes Gabriel is correct .. > Even I got into same issue and it got resolved by MSCK repair table > .command > On Feb 20, 2016 12:35 AM, "Gabriel Balan" > wrote: > >> Hi >> >> It's not enough to make dirs in hdfs.

External table returns no result.

2016-02-18 Thread Amrit Jangid
Hi, Trying to run queries over HDFS data using Hive external table. Created a table using the following syntax but select * from stats returns no result. CREATE EXTERNAL TABLE `stats`( > `filename` string, > `ts` string, > `type` string, > `module` string, > `method` string, > `line` string, > `

Re: How can we find Hive version from Hive CLI or Hive shell?

2016-02-16 Thread Amrit Jangid
>>hive --version Hive 0.13.1-cdh5.3.5 On Wed, Feb 17, 2016 at 11:33 AM, Abhishek Dubey wrote: > Hi, > > > > How can we find Hive version from Hive CLI or Hive shell? > > > > *Thanks & Regards,* > *Abhishek Dubey* > > > -- Regards, Amrit DataPlatform Team --

Re: Hotels.com

2015-11-29 Thread Amrit Jangid
?? On Mon, Nov 30, 2015 at 11:56 AM, Roshini Johri wrote: > [image: Inline image 2] > > Roshini Johri > > [image: Inline image 1] > > > > She borrowed the book from him many years ago and hasn't yet returned it. > She advised him to come back at once. Someone

Fwd: hive.HiveImport: FAILED:

2015-10-25 Thread Amrit Jangid
Hi All, I'm running a sqoop job for a table to import into Hive from mysql, sometimes its works fine.but some time throw this Error: * INFO hive.HiveImport: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:javax.jdo.JDODataStoreException: