[
https://issues.apache.org/jira/browse/CARBONDATA-2542?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16523438#comment-16523438
]
xubo245 commented on CARBONDATA-2542:
-------------------------------------
please update this jira.
> 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: xubo245
> Priority: Major
>
> 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)
