[ 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)