[ https://issues.apache.org/jira/browse/SPARK-10794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14946865#comment-14946865 ]
Anilkumar Kalshetti commented on SPARK-10794: --------------------------------------------- Jia Li Thanks for trying. Looking at the screenshot you provided, I can say that, you are connecteing to Hive [not to Spark-SQL] In beeline interface you used command: !connect jdbc:hive2:// This is connecting to Hive default port 10000 It displayed connection message Connected to: Apache Hive (Version1.2.1.spark) Please refer my screenshot:binaryDataType.png Observe 8th line- Connected to: Spark SQL (version 1.5.0)<-Expected I have started spark thriftserver on port 10001. and connected through beeline interface with port 10001. Thanks, Anil > 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: Critical > Attachments: binaryDataType.png, spark_1_5_0.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