Afaik, it was restricted by implementation of hadoop. But now hadoop-2
supports custom delimiter, hopefully it also can be implemented in hive.
I'm not sure but currently possible way of do that is setting
"textinputformat.record.delimiter" in table properties.
Thanks,
Navis
2014-12-18 6:20 GMT+
I see, thanks for the explaination!
Xiaoyong
From: Alan Gates [mailto:ga...@hortonworks.com]
Sent: Thursday, December 18, 2014 8:05 AM
To: Xiaoyong Zhu
Cc: user@hive.apache.org
Subject: Re: relationship between a hive query and a tez dag
DDL operations are done from the client, not as part of a
DDL operations are done from the client, not as part of a Tez DAG.
There still is no linkage between the DAGs even if they access the same
tables or somehow depend on each other. Hive manages making sure
queries are executed in the order given. Tez just executed each query.
Alan.
Xiaoyong
Hi,
I am trying to create table for a text file who has a row delimiter other
than new line character. I know hive create table does not support anything
other than new line. I have columns where in data contains new line so i
specified a new line character in my sqoop. What are the best options a
With 0.14 is it possible to use the INSERT...VALUES statement to insert data
into a table with complex types like arrays, maps, etc? We will never be
loading data from a file which is why I ask.
Hi,
I am quite new to Hive. I just wonder if a query like this is possible in
hive?
select * from events where events.pid = '123' having count(events.id) > 2
or more precisely is it possible to use " having count(events.id) > 2" in
Hive SQL ?
best,
/Shahab
Hi Arthur
Have a look at here
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-PermanentFunctions
*RegardsMuthupandi.K*
Think before you print.
On Wed, Dec 17, 2014 at 2:53 PM, arthur.hk.c...@gmail.com <
arthur.hk.c...@gmail.com> wrote:
>
> Hi,
>
>
Hi,
Please help!
I am using hiveserver2 on HIVE 0.13 on Hadoop 2.4.1, also
nexr-hive-udf-0.2-SNAPSHOT.jar
I can run query from CLI, e.g.
hive> SELECT add_months(sysdate(), +12) FROM DUAL;
Execution completed successfully
MapredLocal task succeeded
OK
2015-12-17
Time taken: 7.393 seconds, Fetche
