Anilkumar Kalshetti created SPARK-10794:
-------------------------------------------
Summary: Spark-SQL- select query on table column with binary Data
Type displays error message- java.lang.ClassCastException: java.lang.String
cannot be cast to [B
Key: SPARK-10794
URL: https://issues.apache.org/jira/browse/SPARK-10794
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 1.5.0
Environment: Spark 1.5.0 running on MapR 5.0 sandbox
Reporter: Anilkumar Kalshetti
Priority: Minor
Use beeline interface for Spark-SQL
1] Execute below query to create Table,
CREATE TABLE default.testbinary (
c1 binary,
c2 string)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
STORED AS TEXTFILE;
2] Copy the attachment file: testbinary.txt in VM directory - /home/mapr/data/
and execute below script to load data in table
LOAD DATA LOCAL INPATH '/home/mapr/data/testbinary.txt' INTO TABLE testbinary
//testbinary.txt contains data
1001,'russia'
3] Execute below 'Describe' command to get table information, and select
command to get table data
describe testbinary;
SELECT c1 FROM testbinary;
4] Select query displays error message:
java.lang.ClassCastException: java.lang.String cannot be cast to [B
Info: for same table - select query on column c2 - string datatype works
properly
SELECT c2 FROM testbinary;
Please refer screenshot- binaryDataType.png
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
