WebHCat and knox

2016-02-05 Thread Rachna Jotwani
Could someone send me an example of how to authenticate with apache knox for templeton ? I tried the example below , but it doesn't work. Thanks Rachna package com.test.hadoop; import java.io.BufferedReader; import java.io.IOException; import java.io.InputStreamReader; import java.net.HttpURL

RE: Sessionize using Hive

2016-02-05 Thread Ryan Harris
I don't have a textbook example to point you to, but you should be able to handle the problem either using: a) a UDF b) an external TRANSFORM script in a language of your choosing c) using Hive Windowing and Analytics functions (Lead/Lag, over, etc) https://cwiki.apache.org/confluence/display/Hiv

RE: Sessionize using Hive

2016-02-05 Thread JB Rawlings
Ryan, Can you perhaps point me to example(s) of how this is done in Hive? Thanks, J. B. Rawlings Senior Consultant C: 425.233.1315 www.societyconsulting.com From: Ryan Harris [mailto:ryan.har...@zionsbancorp.com] Sent: Monday, February 1, 2016 6:19 PM To: user

Any idea on setting up UDF when hive.security.authorization.enabled=TRUE

2016-02-05 Thread Fan Xu
Hi, Our custom jar is blocked when hive.security.authorization.enable parameter is turned on. I know the parameter is to designed to disable the hive client authorization. But when we have to turn on this parameter, do we still have a way to add our custom jar? Thanks, Fan

Hive Permanent functions not working after a cluster restart.

2016-02-05 Thread Chagarlamudi, Prasanth
I created permanent functions(rather than temp functions) in Hive to use it across different sessions. It all works fine until I actually restart the hive server or cluster for any reason. So is this the intended functionality of Permanent functions? Here is the hive doc link for Permanent func

RE: Adding custom jars for hive and map-reduce jobs dynamically from hdfs location

2016-02-05 Thread Chagarlamudi, Prasanth
Thanks a lot Yehuda. That helped me. From: Yehuda Finkelstein [mailto:yeh...@veracity-group.com] Sent: Monday, February 01, 2016 11:57 AM To: user@hive.apache.org Subject: Re: Adding custom jars for hive and map-reduce jobs dynamically from hdfs location hive.aux.jars.path /var/lib/hive

Re: NPE from simple nested ANSI Join

2016-02-05 Thread Dave Nicodemus
Entered : https://issues.apache.org/jira/browse/HIVE-13012 On Thu, Feb 4, 2016 at 6:58 PM, Sergey Shelukhin wrote: > The stack below looks like a bug; Hive should support joins like these, or > it should fail with a parse error, not an NPE. Can you open a JIRA? > > On 16/2/4, 15:15, "Nicholas Ha

RE: Apache hive Thrift PHP

2016-02-05 Thread Archana Patel
Hey thanks for response.. Actually i don't find any package name with this "thriftif". So would do elloborate it and give me a direction so that i could accomplish this task. From: Gopal Vijayaraghavan [go...@hortonworks.com] on behalf of Gopal Vijayarag

RE: Apache hive Thrift PHP

2016-02-05 Thread Archana Patel
Hi thanks for your response. Have you integrated hiveserver2 with php?. I am stuck on it... so what kind of information you require to help me? From: sreebalineni . [sreebalin...@gmail.com] Sent: Friday, February 05, 2016 5:11 PM To: user@hive.apache.org Su

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: Apache hive Thrift PHP

2016-02-05 Thread Gopal Vijayaraghavan
>I have configured hadoop2.7 and apache hive 1.2.1. I want to connect >Apache hive to php using thrift. That's likely to have a lot of pain due to the way different PHP SAPIs handle timeouts. The only place where the thrift API might work correctly is the CLI mode. >/usr/local/hive/lib/php/pac

RE: NPE from simple nested ANSI Join

2016-02-05 Thread Mich Talebzadeh
Hi Dave, Your schema looks like this NATION --< CUSTOMER --< ORDERS I have a similar schema with the following relationship COUNTRIES --< CUSTOMERS --< SALES I tried this one and it works both in Hive 1.2.1 and Spark getting total sales for each country SELECT c.country_nam