[jira] [Updated] (CARBONDATA-2662) MV creation success but select is failed for other than default database

[Akash R Nilugal (Jira)]

     [ https://issues.apache.org/jira/browse/CARBONDATA-2662?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

xubo245 updated CARBONDATA-2662:
--------------------------------
    Description:
{code:java}
0: jdbc:hive2://hadoop1:10000>  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.152 seconds)
0: jdbc:hive2://hadoop1:10000> create database babu;
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (0.071 seconds)
0: jdbc:hive2://hadoop1:10000> use babu;
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (0.009 seconds)
0: jdbc:hive2://hadoop1:10000>  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.115 seconds)
0: jdbc:hive2://hadoop1:10000> use default
0: jdbc:hive2://hadoop1:10000> ;
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (0.009 seconds)
0: jdbc:hive2://hadoop1:10000> create datamap datamap66 using 'mv' as select doj,sum(salary) from babu.fact10 group by doj;
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (0.295 seconds)
0: jdbc:hive2://hadoop1:10000>  create datamap datamap68 using 'mv' as select doj,sum(salary) from fact10 group by doj;
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (0.311 seconds)
0: jdbc:hive2://hadoop1:10000> rebuild datamap datamap66;
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (0.909 seconds)
0: jdbc:hive2://hadoop1:10000>  select doj,sum(salary) from babu.fact10 group by doj;
Error: org.apache.spark.sql.AnalysisException: Table or view not found: datamap66_table; line 3 pos 2 (state=,code=0)
0: jdbc:hive2://hadoop1:10000>

0: jdbc:hive2://hadoop1:10000> drop datamap datamap66;
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (0.338 seconds)
0: jdbc:hive2://hadoop1:10000>  select doj,sum(salary) from babu.fact10 group by doj;
+------+--------------+--+
| doj  | sum(salary)  |
+------+--------------+--+
+------+--------------+--+
No rows selected (0.201 seconds)

{code}


  was:

{code:java}
0: jdbc:hive2://hadoop1:10000>  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.152 seconds)
0: jdbc:hive2://hadoop1:10000> create database babu;
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (0.071 seconds)
0: jdbc:hive2://hadoop1:10000> use babu;
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (0.009 seconds)
0: jdbc:hive2://hadoop1:10000>  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.115 seconds)
0: jdbc:hive2://hadoop1:10000> use default
0: jdbc:hive2://hadoop1:10000> ;
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (0.009 seconds)
0: jdbc:hive2://hadoop1:10000> create datamap datamap66 using 'mv' as select doj,sum(salary) from babu.fact10 group by doj;
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (0.295 seconds)
0: jdbc:hive2://hadoop1:10000>  create datamap datamap68 using 'mv' as select doj,sum(salary) from fact10 group by doj;
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (0.311 seconds)
0: jdbc:hive2://hadoop1:10000> rebuild datamap datamap66;
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (0.909 seconds)
0: jdbc:hive2://hadoop1:10000>  select doj,sum(salary) from babu.fact10 group by doj;
Error: org.apache.spark.sql.AnalysisException: Table or view not found: datamap66_table; line 3 pos 2 (state=,code=0)
0: jdbc:hive2://hadoop1:10000>

{code}

> MV creation success but select is failed for other than default database
> ------------------------------------------------------------------------
>
>                 Key: CARBONDATA-2662
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2662
>             Project: CarbonData
>          Issue Type: Bug
>            Reporter: xubo245
>            Assignee: xubo245
>            Priority: Major
>
> {code:java}
> 0: jdbc:hive2://hadoop1:10000>  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.152 seconds)
> 0: jdbc:hive2://hadoop1:10000> create database babu;
> +---------+--+
> | Result  |
> +---------+--+
> +---------+--+
> No rows selected (0.071 seconds)
> 0: jdbc:hive2://hadoop1:10000> use babu;
> +---------+--+
> | Result  |
> +---------+--+
> +---------+--+
> No rows selected (0.009 seconds)
> 0: jdbc:hive2://hadoop1:10000>  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.115 seconds)
> 0: jdbc:hive2://hadoop1:10000> use default
> 0: jdbc:hive2://hadoop1:10000> ;
> +---------+--+
> | Result  |
> +---------+--+
> +---------+--+
> No rows selected (0.009 seconds)
> 0: jdbc:hive2://hadoop1:10000> create datamap datamap66 using 'mv' as select doj,sum(salary) from babu.fact10 group by doj;
> +---------+--+
> | Result  |
> +---------+--+
> +---------+--+
> No rows selected (0.295 seconds)
> 0: jdbc:hive2://hadoop1:10000>  create datamap datamap68 using 'mv' as select doj,sum(salary) from fact10 group by doj;
> +---------+--+
> | Result  |
> +---------+--+
> +---------+--+
> No rows selected (0.311 seconds)
> 0: jdbc:hive2://hadoop1:10000> rebuild datamap datamap66;
> +---------+--+
> | Result  |
> +---------+--+
> +---------+--+
> No rows selected (0.909 seconds)
> 0: jdbc:hive2://hadoop1:10000>  select doj,sum(salary) from babu.fact10 group by doj;
> Error: org.apache.spark.sql.AnalysisException: Table or view not found: datamap66_table; line 3 pos 2 (state=,code=0)
> 0: jdbc:hive2://hadoop1:10000>
> 0: jdbc:hive2://hadoop1:10000> drop datamap datamap66;
> +---------+--+
> | Result  |
> +---------+--+
> +---------+--+
> No rows selected (0.338 seconds)
> 0: jdbc:hive2://hadoop1:10000>  select doj,sum(salary) from babu.fact10 group by doj;
> +------+--------------+--+
> | doj  | sum(salary)  |
> +------+--------------+--+
> +------+--------------+--+
> No rows selected (0.201 seconds)
> {code}

--
This message was sent by Atlassian JIRA
(v7.6.3#76005)