any files already there. I'm paranoid, so I
would write to a different directory and then move the files over...
dean
On Wed, Feb 13, 2013 at 1:26 PM, Michael Malak michaelma...@yahoo.com wrote:
Is it possible to INSERT INTO TABLE t SELECT FROM where t has a column with a
STRUCT?
Based
It seems that all Hive columns (at least those of primitive types) are always
NULLable? What about columns of type STRUCT?
The following:
echo 1,2 twovalues.csv
hive
CREATE TABLE tc (x INT, y INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';
LOAD DATA LOCAL INPATH 'twovalues.csv' INTO TABLE
If no one has any objection, I'm going to update HIVE-4022, which I entered a
week ago when I thought the behavior was Avro-specific, to indicate it actually
affects even native Hive tables.
https://issues.apache.org/jira/browse/HIVE-4022
--- On Fri, 2/15/13, Michael Malak michaelma
--- On Sun, 5/5/13, Peter Chu pete@outlook.com wrote:
I am wondering if there is any way to do this without resorting to
using left outer join and finding nulls.
I have found this to be an acceptable substitute. Is it not working for you?
[]);
INSERT INTO table_a
SELECT a, b, ARRAY(SELECT c FROM table_c WHERE table_c.parent = table_b.id)
FROM table_b
From: Edward Capriolo edlinuxg...@gmail.com
To: user@hive.apache.org user@hive.apache.org; Michael Malak
michaelma...@yahoo.com
Sent: Wednesday
I've created
https://issues.apache.org/jira/browse/HIVE-4771
to track this issue.
- Original Message -
From: Michael Malak michaelma...@yahoo.com
To: user@hive.apache.org user@hive.apache.org
Cc:
Sent: Wednesday, June 19, 2013 2:35 PM
Subject: Re: INSERT non-static data to array
.
From: Edward Capriolo edlinuxg...@gmail.com
To: user@hive.apache.org user@hive.apache.org; Michael Malak
michaelma...@yahoo.com
Sent: Thursday, June 20, 2013 9:15 PM
Subject: Re: INSERT non-static data to array?
i think you could select into as sub query and then use
Just copy and paste the whole long expressions to their second occurrences.
From: dyuti a hadoop.hiv...@gmail.com
To: user@hive.apache.org
Sent: Friday, June 28, 2013 10:58 AM
Subject: Fwd: Need urgent help in hive query
Hi Experts,
I'm trying with the
I have found that for output larger than a few GB, redirecting stdout results
in an incomplete file. For very large output, I do CREATE TABLE MYTABLE AS
SELECT ... and then copy the resulting HDFS files directly out of
/user/hive/warehouse.
From: Bertrand
Untested:
SELECT a.c100, a.c300, b.c400
FROM t1 a
JOIN t2 b
ON a.c200 = b.c200
JOIN (SELECT DISTINCT a.c100
FROM t1 a2
JOIN t2 b2
ON a2.c200 = b2.c200
WHERE b2.c400 = SYSDATE - 1) a3
ON a.c100 = a3.c100
WHERE b.c400 = SYSDATE - 1
AND a.c300 = 0
Perhaps you can first create a temp table that contains only the records that
will match? See the UNION ALL trick at
http://www.mail-archive.com/hive-user@hadoop.apache.org/msg01906.html
From: Brad Ruderman bruder...@radiumone.com
To: user@hive.apache.org
Thus far, I've been able to create Hive UDFs, but now I need to define them
within a Java package name (as opposed to the default Java package as I had
been doing), but once I do that, I'm no longer able to load them into Hive.
First off, this works:
add jar
; Michael Malak
michaelma...@yahoo.com
Sent: Tuesday, July 30, 2013 7:06 PM
Subject: Re: UDFs with package names
It might be a better idea to use your own package com.mystuff.x. You might be
running into an issue where java is not finding the file because it assumes the
relation between package
13 matches
Mail list logo
