Yeah, thanks Stephen. I dug~!
On Wed, Oct 23, 2013 at 5:58 PM, Stephen Sprague wrote:
> yeah. that works as expected. the schema drives the column list in the
> select statement (not the hdfs file.)
>
> you'd have nulls if your schema had *more* columns than the hdfs file had
> fields.
>
> you
yeah. that works as expected. the schema drives the column list in the
select statement (not the hdfs file.)
you'd have nulls if your schema had *more* columns than the hdfs file had
fields.
you dig?
On Wed, Oct 23, 2013 at 4:53 PM, Xiu Guo wrote:
> We have a table called employee.dat with
We have a table called employee.dat with below contents:
1,ryan,d'souza,it,2
2,michael,fernandes,admin,25000
then in Hive, query:
create table myTbl (a INT, b STRING)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
TBLPROPERTIES ("serialization.null.format"="\\N");
LO