Re: select * from table and select column from table in hive

2014-10-21 Thread Sanjay Subramanian
; /path/to/local/file.txt    From: Nitin Pawar To: Raj Hadoop ; user@hive.apache.org Sent: Monday, October 20, 2014 12:11 PM Subject: Re: select * from table and select column from table in hive whats your table create ddl?is the data in csv like format? On 21 Oct 2014 00:26, "Raj Hadoop

Re: select * from table and select column from table in hive

2014-10-20 Thread Nitin Pawar
whats your table create ddl? is the data in csv like format? On 21 Oct 2014 00:26, "Raj Hadoop" wrote: > I am able to see the data in the table for all the columns when I issue > the following - > > SELECT * FROM t1 WHERE dt1='2013-11-20' > > > But I am unable to see the column data when i issue

select * from table and select column from table in hive

2014-10-20 Thread Raj Hadoop
I am able to see the data in the table for all the columns when I issue the following - SELECT * FROM t1 WHERE dt1='2013-11-20' But I am unable to see the column data when i issue the following - SELECT cust_num FROM t1 WHERE dt1='2013-11-20' The above shows null values. How should I de