[jira] [Updated] (HIVE-5221) Issue in colun type with data type as BINARY

2013-09-09 Thread Arun Vasu (JIRA) 

 [ 
https://issues.apache.org/jira/browse/HIVE-5221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Arun Vasu updated HIVE-5221:


Priority: Critical  (was: Major)

 Issue in colun type with data type as BINARY
 

 Key: HIVE-5221
 URL: https://issues.apache.org/jira/browse/HIVE-5221
 Project: Hive
  Issue Type: Bug
Reporter: Arun Vasu
Priority: Critical

 Hi,
 I am using Hive 10. When I create an external table with column type as 
 Binary, the query result on the table is showing some junk values for the 
 column with binary datatype.
 Please find below the query I have used to create the table:
 CREATE EXTERNAL TABLE BOOL1(NB BOOLEAN,email STRING, bitfld BINARY)
  ROW FORMAT DELIMITED
FIELDS TERMINATED BY '^'
LINES TERMINATED BY '\n'
 STORED AS TEXTFILE
 LOCATION '/user/hivetables/testbinary';
 The query I have used is : select * from bool1
 The sample data in the hdfs file is:
 0^a...@abc.com^001
 1^a...@abc.com^010
  ^a...@abc.com^011
  ^a...@abc.com^100
 t^a...@abc.com^101
 f^a...@abc.com^110
 true^a...@abc.com^111
 false^a...@abc.com^001
 123^^01100010
 12344^^0111
 Please share your inputs if it is possible.
 Thanks,
 Arun

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Created] (HIVE-5221) Issue in colun type with data type as BINARY

2013-09-05 Thread Arun Vasu (JIRA) 
Arun Vasu created HIVE-5221:
---

 Summary: Issue in colun type with data type as BINARY
 Key: HIVE-5221
 URL: https://issues.apache.org/jira/browse/HIVE-5221
 Project: Hive
  Issue Type: Bug
Reporter: Arun Vasu


Hi,
I am using Hive 10. When I create an external table with column type as Binary, 
the query result on the table is showing some junk values for the column with 
binary datatype.

Please find below the query I have used to create the table:

CREATE EXTERNAL TABLE BOOL1(NB BOOLEAN,email STRING, bitfld BINARY)
 ROW FORMAT DELIMITED
   FIELDS TERMINATED BY '^'
   LINES TERMINATED BY '\n'
STORED AS TEXTFILE
LOCATION '/user/hivetables/testbinary';

The query I have used is : select * from bool1

The sample data in the hdfs file is:

0^a...@abc.com^001
1^a...@abc.com^010
 ^a...@abc.com^011
 ^a...@abc.com^100
t^a...@abc.com^101
f^a...@abc.com^110
true^a...@abc.com^111
false^a...@abc.com^001
123^^01100010
12344^^0111

Please share your inputs if it is possible.

Thanks,
Arun

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira