row_number() over(Partition by) Throw Error with Null Input.

Hi, select row_number() over (PARTITION BY country,state,department,branch_name) from Employee_details; select count(*) over (PARTITION BY country,state,department,branch_name) from Employee_details; These queries throw Error when Employee_details table has zero rows They work great if the tabl

Windowing function row_number() over (PARTITION BY(col1,clo2,col3)

Hi, Windowing function row_number() over (PARTITION BY(col1,clo2,col3) throw error on Empty Table in Hive Version .13 Is there any limitation using this function Thanks, Karthi

Templeton API- No WaitForJobToComplete.

Hey Guys, I am trying to submit Hive Jobs using Templeton API. I am using this Templeton for the first time. How should i wait for the TempletonController job to be completed and exit the job? Unlike WebHCatHttpClient, Templeton doesnt have WaitForJobToComplete. Please let me how do you deal wi

Re: Tez Vertex failure

Is ur Query working when you set hive.execution.engine=mr..? On Fri, Oct 3, 2014 at 7:20 PM, Echo Li wrote: > thanks for reply! > > the query is: *select count(customerid) from tableName where ymd=20140930 > ;* > > when I try to get the application logs only got this: > > > > > > > > > > > *dag_

Re: List of dates as arguments

Sun, Aug 24, 2014 at 2:56 PM, karthik Srivasthava < karthiksrivasth...@gmail.com> wrote: > Yes.. Its working > > > On Sun, Aug 24, 2014 at 2:31 PM, Bala Krishna Gangisetty < > b...@altiscale.com> wrote: > >> Yes, it does. Did you enclose the currentdate value in

Re: List of dates as arguments

Yes.. Its working On Sun, Aug 24, 2014 at 2:31 PM, Bala Krishna Gangisetty wrote: > Yes, it does. Did you enclose the currentdate value in ' ', or " "? > > > > On Sun, Aug 24, 2014 at 12:22 PM, karthik Srivasthava < > karthiksrivasth...@gmail.com> wr

Re: List of dates as arguments

startdate and enddate must be enclosed in ' '. >>> >>> Hope this helps. >>> >>> --Bala G. >>> >>> >>> On Sun, Aug 24, 2014 at 12:57 AM, Nitin Pawar >>> wrote: >>> >>>> I am not sure if you can t

Re: List of dates as arguments

ate and end date >> hive $HIVEPARAMS -hiveconf startdate="$var1" -hiveconf enddate="$var2" >> >> also set in ..hiverc >> set hive.variable.substitute=true; >> >> >> On Sun, Aug 24, 2014 at 10:19 AM, karthik Srivasthava < >> karthiksri

List of dates as arguments

As my raw-data table is partitioned by date.. i want to get data to run a query every days to find top 10 products in last 15 days . How to pass list of dates dynamically as arguments in hive query using hiveconf?

Re: Passing variables using Hiveconf

pts="-server -Xmx1200m -Djava.net.preferIPv4Stack=true" > > and you need to set this variable > > set hive.variable.substitute=true; > > > > On Fri, Aug 22, 2014 at 9:24 PM, karthik Srivasthava < > karthiksrivasth...@gmail.com> wrote: > >> Hi, >> >> I

Passing variables using Hiveconf

Hi, I am passing substitution variable using hiveconf in Hive.. But i couldnt execute simple queries when i am trying to pass more than one parameter. It throws NoViableAltException - AtomExpression.. Am i missing something.?

Re: Yarn Containers using all the space

apologies if it doesnt make any sense.. But please tell me where i made mistake On Sat, Aug 16, 2014 at 6:21 PM, Siddharth Tiwari wrote: > Whats the value set in yarn-site ? Can you paste here ? > > Sent from my iPhone > > On Aug 16, 2014, at 8:19 PM, "karthik Srivasthava&

Re: Yarn Containers using all the space

On Sat, Aug 16, 2014 at 3:34 PM, Manoj wrote: > Tweak parameters to control container memory allocation. Take a look at > this: > http://hortonworks.com/blog/how-to-plan-and-configure-yarn-in-hdp-2-0/ > > On Aug 16, 2014, at 12:58 PM, karthik Srivasthava < > karthiksrivast

Re: Yarn Containers using all the space

Thanks manoj for ur response. But i struggle to run another application in same node as first yarn application using all the available RAM . On Sat, Aug 16, 2014 at 11:44 AM, Manoj wrote: > Look into setting up yarn queues and quotas. > > > On Aug 16, 2014, at 8:15 AM, karthik

Yarn Containers using all the space

I am using TEZ as Hive Execution Engine. When i run a query , Yarn Containers are using all the space available in node. This doesnt allow another query to run. Am i missing any configuration settings here. Please let me know guys where the error might be. Thanks in advance, Karthik

New to TEZ

Hi, This might be very silly error. Below was my log.. I couldnt find where the error is. Can you please point out what caused my error... Regards, Karthik . Map 1: -/- Reducer 2: 0/20 Map 1: 0/138Reducer 2: 0/20 Map 1: 0/138Reducer 2: 0/20 Map 1: 0/138Reducer 2: 0/20 Map 1: 0