[
https://issues.apache.org/jira/browse/CARBONDATA-644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Liang Chen resolved CARBONDATA-644.
-----------------------------------
Resolution: Fixed
Fix Version/s: 1.0.0-incubating
> Select query fails randomly on spark shell
> ------------------------------------------
>
> Key: CARBONDATA-644
> URL:
https://issues.apache.org/jira/browse/CARBONDATA-644> Project: CarbonData
> Issue Type: Bug
> Components: data-query
> Affects Versions: 1.0.0-incubating
> Environment: spark 1.6.2
> Reporter: Deepti Bhardwaj
> Assignee: Ravindra Pesala
> Priority: Minor
> Fix For: 1.0.0-incubating
>
> Attachments: connectdemo1.csv, eror-log-while-select
>
>
> I created a carbon table and loaded it with data(csv attached) via spark shell by running the below command from $SPARK_HOME/bin :
> ./spark-shell
> and then to get the carbon context :
> import org.apache.spark.sql.CarbonContext;
> val cc = new CarbonContext(sc);
> CREATE AND LOAD COMMANDS:
> scala>cc.sql("CREATE TABLE connectdemo1 (name String, gender String, province String , singler String, age Int) STORED BY 'org.apache.carbondata.format'");
> scala>cc.sql("LOAD DATA inpath 'hdfs://localhost:54310/BabuStore/Data/uniqdata/connectdemo1.csv' INTO table connectdemo1 options('DELIMITER'=',','FILEHEADER'='name, gender, province, singler, age')");
> The above two operations were successful but when I tried to run the select query, it failed giving me the java.io.FileNotFoundException(see the log attached)
> scala> cc.sql("select * from connectdemo1").show();
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)