1. The following query works in Hive0.12 but not is hive0.13. Note, in
hive0.12 the following query will not compile if we remove one of the Day
column from group by.
SELECT DAY, daypart, 'DAY' AS DIMENSION, `day` AS VALUE, SUM(`total`) AS T
FROM H_ANKITEST GROUP BY DAY, `day` , daypart
FAI
#x27;t
> one) to generate integer array from the striped string.
>
>
> On Mon, Sep 22, 2014 at 6:12 PM, Ankita Bakshi
> wrote:
>
>> Hi,
>>
>> I have '|' delimited file where arrays are serialized with square
>> brackets. I am trying create
Hi,
I have '|' delimited file where arrays are serialized with square brackets.
I am trying create a hive table to parse this file.
Example:
first|[1,2,3]|100
second|[11,12,13]|200
Create External Table H_histoTest(dim1 string, hist ARRAY, measure1
bigint)
ROW FORMAT DELIMITED FIELDS
TERMIN
Hi,
I am trying to create an external table which is pointing to a directory
containing symlinks to files in hdfs. I am using CDH 4.4 with Hive 0.12.
When I tried to run a select query on this table it returns 0 rows. And
when I run a count query the map task fails with following error:
014-05-2
