Hi,
I am using Hive 1.2 with ORC tables on Hadoop 2.6 on a cluster.
I load data into an ORC table by reading the data from an external table on
raw text files and using insert statement:
INSERT into TABLE myorctab SELECT * FROM mytxttab;
I ran a simple scale-up test to find out how the loading
Franke <jornfra...@gmail.com> wrote:
> Why not use tez ui?
>
> Le jeu. 1 oct. 2015 à 2:29, James Pirz <james.p...@gmail.com> a écrit :
>
>> I am using Tez 0.7.0 on Hadopp 2.6 to run Hive queries.
>> I am interested in checking DAGs for my queries visua
I am using Tez 0.7.0 on Hadopp 2.6 to run Hive queries.
I am interested in checking DAGs for my queries visually, and I realized
that I can do that by graphviz once I can get "dot" files of my DAGs. My
issue is I can not find those files, they are not in the log directory of
Yarn or Hadoop or
, you will be able to find the contents of the .dot file within them.
> This approach only works if you have YARN log aggregation enabled.
>
> thanks
> — Hitesh
>
>
> On Sep 30, 2015, at 5:29 PM, James Pirz <james.p...@gmail.com> wrote:
>
> > I am using Tez 0.
I am using Hive 1.2.0 on Hadoop 2.6 (on a cluster with 10 machines) and I
am trying to understand the performance of a full-table scan. I am running
the following query:
SELECT * FROM LINEITEM
WHERE L_LINENUMBER < 0;
and I am measuring its performance in different scenarios: using "MR vs.
Tez"
Hi,
I am using Hive 1.2, and I am trying to run some queries based on TPCH
schema. My original query is:
SELECT N_NAME, AVERAGE(C_ACCTBAL)
FROM customer JOIN nation
on C_NATIONKEY=N_NATIONKEY
GROUP BY N_NAME;
for which I get:
FAILED: SemanticException [Error 10025]: Line 1:15 Expression not in
failed to fix it for HiveQL.
On Wed, Jul 29, 2015 at 5:03 PM, James Pirz james.p...@gmail.com wrote:
Hi,
I am using Hive 1.2, and I am trying to run some queries based on TPCH
schema. My original query is:
SELECT N_NAME, AVERAGE(C_ACCTBAL)
FROM customer JOIN nation
on C_NATIONKEY=N_NATIONKEY
, 2015 at 11:52 AM, James Pirz james.p...@gmail.com wrote:
I am trying to run Hive 1.2.0 on Hadoop 2.6.0 (on a cluster, running
CentOS). I am able to start Hive CLI and run queries. But once I try to
start Hive's metastore (I trying to use the builtin derby) using:
hive --service metastore
I
metastore server.
On Mon, Jun 8, 2015 at 1:11 PM, Slava Markeyev slava.marke...@upsight.com
wrote:
Sounds like you ran into this:
https://issues.apache.org/jira/browse/HIVE-9198
On Mon, Jun 8, 2015 at 1:06 PM, James Pirz james.p...@gmail.com wrote:
Thanks !
There was a similar problem