Hi,
I can see that two new counters have been added for hive
(RECORDS_IN/RECORDS_OUT) in hive 0.14.
Prior to this release which counters could be used to get the records read by
hive job and records written. Because i noticed that in hive 0.14 for a few
hive jobs i see map_input_records
Hi Robin,
thanks a lot for the hint about the WITH statement. This is comparable to using
a subselect.
E.g., I could rewrite my query from:
SELECT
actor,
COLLECT_LIST(action) AS actions
FROM
foobar
GROUP BY
actor
SORT BY
actor, ts;
to:
SELECT
actor,
Probably has to do with the fact that it is an Avro table. I don't have any
experience using Avro, but maybe take a look at
https://issues.apache.org/jira/browse/HIVE-7446 for some of the issues
described there, or maybe look at the test that was added for that Jira.
On Jun 16, 2015, at 2:42
iam using *hive 1.0.0* and *tez 0.5.2.* when i set
*hive.execution.engine* value
in hive-site.xml to *tez*select query works well... but in case of
*insert* getting
error. the query is :
*insert into table tablename values(intvalue,'string value');*
and the error is :
*FAILED: Execution Error,
https://github.com/edwardcapriolo/filecrush
On Tue, Jun 16, 2015 at 5:05 PM, Chagarlamudi, Prasanth
prasanth.chagarlam...@epsilon.com wrote:
Hello,
I am looking for an optimized way to merge small files in hive partitions
into one big file.
I came across *Alter Table/Partition
Unless you can pinpoint the problem to something Tez specific, hive-specific
questions might be better off being asked on user@hive initially as there is a
larger group there that understands Hive as compared to the Tez community.
FWIW, TezTask error 1 means “something in the Hive layer using
Hello,
I am looking for an optimized way to merge small files in hive partitions into
one big file.
I came across Alter Table/Partition Concatenate
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterTable/PartitionConcatenate.
Doc says this only works for
You can refer to the following link to figure out whether this is tez problem
https://cwiki.apache.org/confluence/display/TEZ/How+to+Diagnose+Tez+App
Best Regard,
Jeff Zhang
From: Sateesh Karuturi
sateesh.karutu...@gmail.commailto:sateesh.karutu...@gmail.com
Reply-To:
Hi all,
I'm reading the source code of Hive cbo (CalcaitePlanner), but I find it hard
to follow.
Listed below are some of the questions:
1. What's the relationship between HepPlanner and HiveVolcanoPlanner?
2. I don't have a clue about these concepts: clusters, traitDef and
collectGarbage().
Any help?
r7raul1...@163.com
From: r7raul1...@163.com
Date: 2015-06-11 15:53
To: user
Subject: Re: Re: delta file compact take no effect
SHOW COMPACTIONS;
I can see some info
Database Table Partition Type State Worker Start Time
default u_data_txn NULL MAJOR initiated NULL 0
Time taken:
Is the config you give on your metastore or your client? The worker
thread and initiator must be started on the metastore.
Alan.
r7raul1...@163.com mailto:r7raul1...@163.com
June 16, 2015 at 22:38
Any help?
Hi every one,
how to get leftmost length of characters from the string in hive?
In Mysql or sq has specific function
LEFT(string,length)
Could you please help any other way to achieve this scenario?
Regards
Ravisnkar
Hi, can anyone to fix this bug? I think it's important
https://issues.apache.org/jira/browse/HIVE-6992
is there any other way to getMetaData before run the sql?
thanks!
*Push* Does no one have an idea or hit similar issues?
2015-06-09 15:46 GMT+02:00 Julian Keppel juliankeppel1...@gmail.com:
I use Hive Version 1.1.0 in Cloudera CDH 5.4.0.
I have created an external table:
CREATE EXTERNAL TABLE *tableA*
ROW FORMAT SERDE
try using substr function
On Tue, Jun 16, 2015 at 3:03 PM, Ravisankar Mani rrav...@gmail.com wrote:
Hi every one,
how to get leftmost length of characters from the string in hive?
In Mysql or sq has specific function
LEFT(string,length)
Could you please help any other way to achieve
15 matches
Mail list logo