hive lineage info

I want to pring lineage info of sql. I found this jira https://issues.apache.org/jira/browse/HIVE-1131 . How to use it? r7raul1...@163.com

Re: user matching query does not exist

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 ak3...@gmail.com wrote: Yes it is happening for hue only, can u plz suggest how i cleaning

Re: user matching query does not exist

i am using CDH 5.2.1, Any pointers will be of immense help. Thanks On Fri, May 15, 2015 at 9:43 AM, amit kumar ak3...@gmail.com wrote: Hi, After re-create my account in Hue, i receives “User matching query does not exist” when attempting to perform hive query. The query is succeed in

Re: user matching query does not exist

Is this happening for Hue? If yes, may be you can try cleaning up hue sessions from server. (this may clean all users active sessions from hue so be careful while doing it) On Fri, May 15, 2015 at 11:31 AM, amit kumar ak3...@gmail.com wrote: i am using CDH 5.2.1, Any pointers will be of

Re: user matching query does not exist

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 nitinpawar...@gmail.com wrote:

Re: user matching query does not exist

Yes it is happening for hue only, can u plz suggest how i cleaning up hue session from server ? The query is succeed in hive command line. On Fri, May 15, 2015 at 11:52 AM, Nitin Pawar nitinpawar...@gmail.com wrote: Is this happening for Hue? If yes, may be you can try cleaning up hue

RE: Partition Columns

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

Index Rebuild - DUG failes due to vertex failure

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

Re: Index Rebuild - DUG failes due to vertex failure

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 m...@web-computing.de 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

Re: Index Rebuild - DUG failes due to vertex failure

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

Repeated Hive start-up issues

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

Re: Repeated Hive start-up issues

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 anand_vi...@yahoo.com wrote: Hi All: I have installed

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

Re: Repeated Hive start-up issues

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 xzh...@cloudera.com wrote: Your namenode is in safe mode, as the exception shows. You need to

RE: Index Rebuild - DUG failes due to vertex failure

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