Re: VARCHAR or STRING fields in Hive

2017-01-16 Thread sreebalineni .
How is that efficient storage wise because as far as I see it is in hdfs and storage is based on your block size. Am i missing something here? On Jan 16, 2017 9:07 PM, "Mich Talebzadeh" wrote: Coming from DBMS background I tend to treat the columns in Hive similar to an RDBMS table. For examp

Re: LeaseExpiredException in Hive

2016-05-12 Thread sreebalineni .
Please do test with debug mode I suspect it could be access issue of that path or no enough space On May 12, 2016 12:54 PM, "Arun Vasu" wrote: > Hi All, > > I was running 10 hive queries (INSERT INTO TABLE. ) parallel and it is > failing with an exception saying few of the MR jobs cannot find

Re: Issue with Star schema

2016-03-15 Thread sreebalineni .
You can think of map joins.If cluster is configured by default it must be happening already check query profile On Tue, 15 Mar 2016 21:12 Himabindu sanka, wrote: > Hi Team, > > > > I have a query where I am joining with 10 other entities > > > > Like > > > > Select a.col1,b1.col1,b2.col1 from >

Re: Apache hive Thrift PHP

2016-02-05 Thread sreebalineni .
Hello Archangel This looks interesting May I know what's up use case for integrating php and hive On Fri, 5 Feb 2016 11:49 Archana Patel wrote: > Hello, > > I have configured hadoop2.7 and apache hive 1.2.1. I want to connect > Apache hive to php using thrift. I have followed > https://cwiki.ap

Re: export/import in hive failing with nested directory exception!

2015-11-12 Thread sreebalineni .
Hello Gopal, Are there any plans for fixing this? Any idea? On Fri, Nov 13, 2015 at 6:31 AM, Gopal Vijayaraghavan wrote: > Hi, > > >Thanks Gopal. Indeed table t is defined as ORC and transactional. > > > >Any reason why this should not work for transactional tables? > > The committed transaction

Re: Disabling local mode optimization

2015-09-02 Thread sreebalineni .
Hi, Is not it that you should set it true, by default it is disabled which is false. Hive analyzes the size of each map-reduce job in a query and may run it locally if the following thresholds are satisfied: - The total input size of the job is lower than: hive.exec.mode.local.auto.inputby

Re: upgrade of Hadoop cluster from 5.1.2 to 5.2.1.

2015-05-21 Thread sreebalineni .
Hi you need to check if you have access to hdfs directory group.you can find that as on linux id userid and in the output see if you have group.in ur case it seems g-stor something like that check the message permission denied in the logs On May 21, 2015 9:31 AM, "Anupam sinha" wrote: > I have up

Re: CSV file reading in hive

2015-02-13 Thread sreebalineni .
Hi Furcy, Thats lot of information.Thanks a lot On Feb 13, 2015 3:40 PM, "Furcy Pin" wrote: > Hi Sreeman, > > Unfortunately, I don't think that Hive built-in format can currently read > csv files with fields enclosed in double quotes. > More generally, for having ingested quite a lot of messy csv