hive read partitioned tables

[Xiu Li]

I have data stored in S3. Data are already partitioned by year, month, day, hour. How do I read all the data to Hive? Thanks.

[Ashish Dubey]

Though i responded on a different channel but to close this question on the forum - let me paste it again:

Example:

CREATE EXTERNAL TABLE page_view(viewTime INT, userid BIGINT,
page_url STRING, referrer_url STRING,
ip STRING COMMENT 'IP Address of the User')
COMMENT 'This is the page view table'
PARTITIONED BY(dt STRING, country STRING)
LOCATION 's3://abc/xyz';

Alter Table page_view Recover Partitions;

Hope this helps.

On Mon, Mar 7, 2016 at 8:18 AM, Xiu Li <lixiu...@gmail.com> wrote:

I have data stored in S3. Data are already partitioned by year, month, day, hour. How do I read all the data to Hive? Thanks.

--
You received this message because you are subscribed to the Google Groups "Qubole Public Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to qubole-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/qubole-users/56dda9e616afc_5c082add460fc76c581b8%40ip-10-61-166-109.mail.
For more options, visit https://groups.google.com/d/optout.