Ok, thanks for this solution.
Unfortunately, i have rewrited my script like this :
INSERT INTO TABLE default.THM_CA_RGRP_PRODUITS_SEM
SELECT
'${hiveconf:in_co_societe}' as co_societe,
'${hiveconf:in_co_an_semaine}'as co_an_semaine,
a.type
awright Jerome. look closely at the error message. you can figure this one
out.
On Fri, Aug 30, 2013 at 1:17 AM, Jérôme Verdier
wrote:
> Ok, thanks for this solution.
>
> Unfortunately, i have rewrited my script like this :
>
> INSERT INTO TABLE default.THM_CA_RGRP_PRODUITS_SEM
>
> SELE
Thanks Stephen,
Yes i realise that it was so a stupid questionMaybe i wasn't really
awaked this morning ;-)
now it's working well.
Thanks everyone.
2013/8/30 Stephen Sprague
> awright Jerome. look closely at the error message. you can figure this
> one out.
>
>
> On Fri, Aug 30, 2013 at
Hi,
Is it possible to have multiple conditions in Having clause ?
I get an error when i'm trying this.
Thanks a lot.
2013/8/30 Jérôme Verdier
> Thanks Stephen,
>
> Yes i realise that it was so a stupid questionMaybe i wasn't really
> awaked this morning ;-)
>
> now it's working well.
>
>
Hi All-
I was hoping to gather some insight in how the hadoop (and or hive) job
scheduler distributes mappers per user. I am running into an issue where I
see that hadoop (and or hive) is evenly distributing mappers per user
instead of per job.
For example:
-We have 1000 mapper capacity
-10 Jobs a
I am writing a UDF that will perform validation on the input row and shall
require access to every column in the row (or alternatively to simply the
unparsed/pre-processed line).
Is there any way to achieve this? Or will it be simply necessary to
declare an overloaded evaluate() method with a sig
I have multiple tables, and was trying to recursively join them. The first join
finishes with no error but not the second
i am not sure if it have something to do using hive tables as input to the next
join... because every time I use external tables that i created there is no
error at all, it
Hi Brad,
I believe you have configured a Capacity Scheduler for scheduling the
jobs rather than the default FIFO scheduler.
Regards
Ravi Magham
On Fri, Aug 30, 2013 at 10:07 PM, Brad Ruderman wrote:
> Hi All-
> I was hoping to gather some insight in how the hadoop (and or hive) job
> schedul
and you can find that by looking at your mapred-site.xml . look for this
property
mapred-site.xml: mapred.jobtracker.taskScheduler
you should be using the default FIFO or
org.apache.hadoop.mapred.FairScheduler or
org.apache.hadoop.mapred.CapacityTaskScheduler
Depends on what scheduler you are
Hi Kumar and Ravi-
Thanks for your quick responses. Although I don't believe changing anything
from default, it is possible because we are using a distribution. I will
check.
Thanks!
Brad
On Fri, Aug 30, 2013 at 1:46 PM, kumar y wrote:
>
> and you can find that by looking at your mapred-site
there should be no limitation AFAIK. example + error message is always
helpful - even if you might regret it. :)
On Fri, Aug 30, 2013 at 8:16 AM, Jérôme Verdier
wrote:
> Hi,
>
> Is it possible to have multiple conditions in Having clause ?
>
> I get an error when i'm trying this.
>
> Thanks a
I have three tables:
Table 1: record when and who visited gas station or not, this contains all
the users of interest, name all the users as a set A
date | user name| visited gas station?
2013-09-01 tom yes
2013
so this is not particular to Hive is it? You could post this on a DB2,
Oracle, or even Stackflow board i'd imagine.
On Fri, Aug 30, 2013 at 4:34 PM, qiaoresearcher wrote:
>
> I have three tables:
>
> Table 1: record when and who visited gas station or not, this contains all
> the users of intere
Hi guys
I have configured Hive to use MySQL for all statistics
hive.stats.atomic=false
hive.stats.autogather=true
hive.stats.collect.rawdatasize=true
hive.stats.dbclass=jdbc:mysql
hive.stats.dbconnectionstring=jdbc:mysql://v-so1.nextagqa.com/hive_vso1_tempstatsstore?&user=hive_user_vso1&password=
Hi Sanjay,
What do the logs say when you fire the ANALYZE TABLE... statement on a
table ?
One minor correction to the db connectionstring would be to use &
for the query parameters.
hive.stats.dbconnectionstring=jdbc:mysql://
v-so1.nextagqa.com/hive_vso1_tempstatsstore?user=hive_user_vso1&
15 matches
Mail list logo