I don't know of anything like what you want atleast until Hive 0.11.
However, you could try something like this:
INSERT OVERWRITE TABLE rollup
SELECT id, start_time, collect_set(concat_ws(,, objects.name,
objects.value, objects.type)) AS product_details
FROM bar
GROUP BY id, start_time;
It's a
Geez, too many mistakes for the day :P
I meant the following above
*CREATE TABLE* rollup_new *AS*
SELECT id, start_time, collect_set(concat_ws(,, object.name
http://objects.name/, object.value, object.type)) AS product_details
FROM bar
GROUP BY id, start_time;
The change is in the table
I have a table defined as:
CREATE TABLE foo (
id INT,
start_time STRING,
name STRING,
value STRING,
type STRING
)
The 'name', 'value' and 'type' fields actually describe another object, and
I'd like to turn these into STRUCTs, something like:
CREATE TABLE bar (
id INT,
start_time
On Wed, Nov 28, 2012 at 1:29 PM, Brad Cavanagh brad.cavan...@gmail.comwrote:
I have a table defined as:
CREATE TABLE foo (
id INT,
start_time STRING,
name STRING,
value STRING,
type STRING
)
The 'name', 'value' and 'type' fields actually describe another object,
and I'd like