[
https://issues.apache.org/jira/browse/SPARK-10794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anilkumar Kalshetti updated SPARK-10794:
----------------------------------------
Description:
Spark-SQL connected to Hive Metastore-- MapR5.0 has Hive 1.0.0
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
was:
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
> 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
> Attachments: binaryDataType.png, testbinary.txt
>
>
> Spark-SQL connected to Hive Metastore-- MapR5.0 has Hive 1.0.0
> 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
