Just found a related ticket: https://issues.apache.org/jira/browse/HIVE-1309
Best Regards,
Nishant Kelkar
On Sun, Nov 2, 2014 at 10:32 PM, Nishant Kelkar
wrote:
> FYI,
>
> I tried the following query too:
>
> *INSERT INTO TABLE* test_table
> *PARTITION* (a="foo", b=*CAST*(NULL *AS* STRING))
> *
FYI,
I tried the following query too:
*INSERT INTO TABLE* test_table
*PARTITION* (a="foo", b=*CAST*(NULL *AS* STRING))
*SELECT* stack(1,
"this is a test string") AS (c)
*FROM* dual;
I get the following error:
FAILED: ParseException line 2:22 cannot recognize input near 'CAST' '('
'NULL' in cons
Hi All,
So I have a table, say *test_table*. It has 3 columns, "a", "b", and "c".
For simplicity, let's say all are of type STRING. Say the table, when
created, was partitioned on fields "a" and "b".
Now, I have the following query:
*INSERT INTO TABLE* *test_table*
*PARTITION* (a="foo", b=NULL)
