Re: Error : "Cannot create a path from empty string"

2015-05-15 Thread Viral Bajaria
Sorry for the delay in responding. I am not trying to run a separate job/query on the intermediate output of another job/query. The error is happening in a multi-job mapreduce query. When one step finishes, the next step is trying to read the output of the previous job and fails with the "can not

Hive schema on read

2015-05-15 Thread Giri P
Hi All, Since hive is schema on read when we try to write data that is different data type into a column it doesn't throw any error. When we try to read it , it actually shoe NULl if its a different data type. Are there any options to throw error if data is of different data type when we try to i

RE: Index Rebuild - DUG failes due to vertex failure

2015-05-15 Thread Mich Talebzadeh
HI Marc, Regardless of whether you rebuild an index or not I came across checking whether indexes are used in Hive. In so far as I know indexes are not fully implemented in Hive and Hive does not use the index. See the attached emails. HTH Mich Talebzadeh http://talebzadehmich

Re: Repeated Hive start-up issues

2015-05-15 Thread Vikas Parashar
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 >

Re: Repeated Hive start-up issues

2015-05-15 Thread Anand Murali
Hi: Many thanks for replying. Can you please tell me how to fix namenode safe mode issue. I am new to Hadoop. Thanks Regards Anand Sent from my iPhone > On 15-May-2015, at 7:14 pm, Xuefu Zhang wrote: > > Your namenode is in safe mode, as the exception shows. You need to verify/fix > that

Re: Repeated Hive start-up issues

2015-05-15 Thread Xuefu Zhang
Your namenode is in safe mode, as the exception shows. You need to verify/fix that before trying Hive. Secondly, "!=" may not work as expected. Try "<>" or other simpler query first. --Xuefu On Fri, May 15, 2015 at 6:17 AM, Anand Murali wrote: > Hi All: > > I have installed Hadoop-2.6, Hive 1.

Repeated Hive start-up issues

2015-05-15 Thread Anand Murali
Hi All: I have installed Hadoop-2.6, Hive 1.1 and try to start hive and get the following, first time when I start the cluster $hive Logging initialized using configuration in jar:file:/home/anand_vihar/hive-1.1.0/lib/hive-common-1.1.0.jar!/hive-log4j.properties SLF4J: Class path contains multi

Re: Index Rebuild - DUG failes due to vertex failure

2015-05-15 Thread Marc Seeger
At Hive-Wiki indexing is described: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Indexing and https://cwiki.apache.org/confluence/display/Hive/IndexDev As I used it first, Index was build. The index table were filled with data and the performance increased. But without changes at

Re: Index Rebuild - DUG failes due to vertex failure

2015-05-15 Thread Dr Mich Talebzadeh
Hi Marc, As far as I know indexes do not work in hive. Have you checked it with explain? Thanks, Mich On 15/5/2015, "Marc Seeger" wrote: >Hi, > >I'm using Hive14 on a HDP2.2-Cluster and have a problem with indexing on >Hive. I can create an index. >create INDEX ix_key ON TABLE DbTest.Tbl_tes

Index Rebuild - DUG failes due to vertex failure

2015-05-15 Thread Marc Seeger
Hi, I'm using Hive14 on a HDP2.2-Cluster and have a problem with indexing on Hive. I can create an index. create INDEX ix_key ON TABLE DbTest.Tbl_test(TEST_KEY) as 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler' WITH DEFERRED REBUILD; After that I loaded data into the table and bui

Re: user matching query does not exist

2015-05-15 Thread amit kumar
Thank you Nitin, When the user runs the query via Hive command line. The query succeeds query like select * from railway; as per the link provided you i fire the command ./manage.py clearsessions ; i get the error. On Fri, May 15, 2015 at 12:32 PM, Nitin Pawar wrote: > this is related to d

RE: Partition Columns

2015-05-15 Thread Martin Benson
Hi Appan, I think the answer is that the parser is not able to detect that partitions are useful in Query 2, because the where condition is on a derived field. i.e. Hive can tell that if you say where some_partition_field=”some partition value” then it only needs to scan that partition, but if

Re: user matching query does not exist

2015-05-15 Thread Nitin Pawar
this is related to djnago see this on how to clear sessions from django http://www.opencsw.org/community/questions/289/how-to-clear-the-django-session-cache On Fri, May 15, 2015 at 12:24 PM, amit kumar wrote: > Yes it is happening for hue only, can u plz suggest how i cleaning up hue > session