First, you need to give your csv file a header. For example,
col1,col2,col3,...etc.
70268503,"2012-09-28 15:00:59",0,",01","18,01",,1,"
2012-10-01 17:01:11",0,,
Then create the table with,
CREATE TABLE IF NOT EXISTS foo (
col1 INT,
col2 STRING,
col3 INT
...
)
ROW
you could use: https://github.com/ogrodnek/csv-serde
That what i have done in the past, but with the latest version of Hive
there might be other options available too.
On Thu, Sep 4, 2014 at 12:43 PM, Ricardo Pompeu Ferreras <
ricardo.ferre...@gmail.com> wrote:
> Hi,
>
> How I create a table wit
Hi,
How I create a table with this structure ?
The separte are , comma,
There are fields with "xx" date and "yyy" with value.
70268503,"2012-09-28 15:00:59",0,",01","18,01",,1,"2012-10-01 17:01:11",0,,
help please
--
Ricardo
SP, Brasil
