Hive version: 0.10.0-cdh4.2.1
Trying to insert into a bucketized table from the same table, throws
exception:
FAILED: SemanticException [Error 10122]: Bucketized tables do not support
INSERT INTO: Table:
To test the scenario, I create the following 3 test tables:
create table temp1
(a int)
Neha, its not a bug. Hive does not support insert into bucketed table as of
now.
There is a patch available for same at
HIVE-3244https://issues.apache.org/jira/browse/HIVE-3244
You can also refer HIVE-3077https://issues.apache.org/jira/browse/HIVE-3077
On Thu, Aug 29, 2013 at 2:32 PM, Neha Sood
Hi everybody,
I am coding some HiveQL script to do some calculations.
I have a problem with the min() function.
My hive script is below :
INSERT INTO TABLE default.THM_CA_RGRP_PRODUITS_SEM
SELECT
'${hiveconf:in_co_societe}' as co_societe,
the min function at column 62 is on on the column b.dt_jour. what datatype
is that?
if its of type 'timestamp' that might explain it.
On Thu, Aug 29, 2013 at 3:01 AM, Jérôme Verdier
verdier.jerom...@gmail.comwrote:
Hi everybody,
I am coding some HiveQL script to do some calculations.
I
Hi stephen,
Thanks for your reply.
Effectively, dt_jour is timestamp format.
What is the problem with this?
-Original Message-
From: Stephen Sprague sprag...@gmail.com
Date: Thu, 29 Aug 2013 09:24:27
To: user@hive.apache.orguser@hive.apache.org
Reply-To: user@hive.apache.org
Subject:
Hi All:
Put some debugging code in TUGIContainingTransport.getTransport() and I
tracked it down to
@Override
public TUGIContainingTransport getTransport(TTransport trans) {
// UGI information is not available at connection setup time, it will be
set later
// via set_ugi() rpc.
well. i would suggest you test whether or not min() works on timestamp
datatype. it seems like something one should rule out first before going
down the rabbit hole further. My opinion only!
On Thu, Aug 29, 2013 at 9:28 AM, Jérôme Verdier
verdier.jerom...@gmail.comwrote:
**
Hi stephen,
Sorry hit send too soon ...
Hi All:
Put some debugging code in TUGIContainingTransport.getTransport() and I
tracked it down to
@Override
public TUGIContainingTransport getTransport(TTransport trans) {
// UGI information is not available at connection setup time, it will be
set later
// via
Looks like the issue is the use of min() within the WHERE clause - the place
where the exception is being thrown has the following comment:
// UDAF in filter condition, group-by caluse, param of funtion, etc.
On Aug 29, 2013, at 3:01 AM, Jérôme Verdier verdier.jerom...@gmail.com wrote:
Aggregate functions need to go in a HAVING clause instead of the WHERE
clause. WHERE clauses are applied prior to aggregation, HAVING is
applied post aggregation.
select ...
from ...
where some row level filter
group by ...
having some aggregate level filter
On Thu, Aug 29, 2013 at 2:49 PM,
Thanks Agatea for digging in. Seems like you have hit a bug. Would you mind
opening a jira and adding your findings to it.
Thanks,
Ashutosh
On Thu, Aug 29, 2013 at 11:22 AM, agateaaa agate...@gmail.com wrote:
Sorry hit send too soon ...
Hi All:
Put some debugging code in
indeed. you nailed it.
On Thu, Aug 29, 2013 at 11:53 AM, John Meagher john.meag...@gmail.comwrote:
Aggregate functions need to go in a HAVING clause instead of the WHERE
clause. WHERE clauses are applied prior to aggregation, HAVING is
applied post aggregation.
select ...
from ...
where
Thanks Ashutosh.
Filed https://issues.apache.org/jira/browse/HIVE-5172
On Thu, Aug 29, 2013 at 11:53 AM, Ashutosh Chauhan hashut...@apache.orgwrote:
Thanks Agatea for digging in. Seems like you have hit a bug. Would you
mind opening a jira and adding your findings to it.
Thanks,
Ashutosh
Thanks Ashutosh.
Filed https://issues.apache.org/jira/browse/HIVE-5172
On Thu, Aug 29, 2013 at 11:53 AM, Ashutosh Chauhan hashut...@apache.orgwrote:
Thanks Agatea for digging in. Seems like you have hit a bug. Would you
mind opening a jira and adding your findings to it.
Thanks,
Ashutosh
14 matches
Mail list logo