You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Jacky Li (JIRA)" <ji...@apache.org> on 2018/07/24 00:55:00 UTC
[jira] [Resolved] (CARBONDATA-2542) MV creation is failed for other
than default database
[ https://issues.apache.org/jira/browse/CARBONDATA-2542?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacky Li resolved CARBONDATA-2542.
----------------------------------
Resolution: Fixed
Assignee: Ravindra Pesala (was: xubo245)
Fix Version/s: 1.4.1
1.5.0
> MV creation is failed for other than default database
> -----------------------------------------------------
>
> Key: CARBONDATA-2542
> URL: https://issues.apache.org/jira/browse/CARBONDATA-2542
> Project: CarbonData
> Issue Type: Bug
> Reporter: Babulal
> Assignee: Ravindra Pesala
> Priority: Major
> Fix For: 1.5.0, 1.4.1
>
> Time Spent: 2h 20m
> Remaining Estimate: 0h
>
> 0: jdbc:hive2://10.18.222.231:23040> CREATE TABLE fact10 (empname String, designation String, doj Timestamp, workgroupcategory int, workgroupcategoryname String, deptno int, deptname String, projectcode int, projectjoindate Timestamp, projectenddate Timestamp,attendance int, utilization int,salary int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('table_blocksize'='256');
> +---------+--+
> | Result |
> +---------+--+
> +---------+--+
> No rows selected (0.962 seconds)
> 0: jdbc:hive2://10.18.222.231:23040> LOAD DATA local inpath '/tmp/babu/data_big_1.csv' INTO TABLE fact10 OPTIONS('DELIMITER'= ',', 'QUOTECHAR'= '"','timestampformat'='dd-MM-yyyy','FILEHEADER'='empno,empname,designation,doj,workgroupcategory,workgroupcategoryname,deptno,deptname,projectcode,projectjoindate,projectenddate,attendance,utilization,salary');
> +---------+--+
> | Result |
> +---------+--+
> +---------+--+
> No rows selected (6.188 seconds)
> 0: jdbc:hive2://10.18.222.231:23040> create datamap datamap66 using 'mv' as select doj,sum(salary) from *babu.fact10* group by doj;
> +---------+--+
> | Result |
> +---------+--+
> +---------+--+
> No rows selected (0.893 seconds)
> 0: jdbc:hive2://10.18.222.231:23040> create datamap datamap68 using 'mv' as select doj,sum(salary) *from fact10* group by doj;
> Error: org.apache.spark.sql.AnalysisException: *Table or view not found: fact10*; line 1 pos 49 (state=,code=0)
> 0: jdbc:hive2://10.18.222.231:23040>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)