[jira] [Comment Edited] (CARBONDATA-1711) Carbon1.3.0-Pre-AggregateTable - Show datamap on table <par_table> does not work

[Akash R Nilugal (Jira)]

    [ https://issues.apache.org/jira/browse/CARBONDATA-1711?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16252943#comment-16252943 ]

Ramakrishna S edited comment on CARBONDATA-1711 at 11/15/17 4:59 AM:
---------------------------------------------------------------------

Similar issue found in these table operations as well:
As per doc:
l User can drop the pre-aggregate table by
DROP DATAMAP agg_sales
l User can show pre-aggregate table by
SHOW DATAMAP ON TABLE sale
l User can get the information of the pre-aggregate table by
DESC DATAMAP agg_sales ON TABLE sales
But they dont seem to work:
0: jdbc:hive2://10.18.98.34:23040> desc datamap agr_lineitem on table lineitems;
Error: java.lang.RuntimeException:
BaseSqlParser>>>>
mismatched input 'on' expecting {<EOF>, '.'}(line 1, pos 26)

== SQL ==
desc datamap agr_lineitem on table lineitems
--------------------------^^^

CarbonSqlParser>>>> [1.1] failure: identifier matching regex (?i)CREATE expected

desc datamap agr_lineitem on table lineitems
^ (state=,code=0)
0: jdbc:hive2://10.18.98.34:23040> SHOW DATAMAP ON TABLE lineitem;
Error: java.lang.RuntimeException:
BaseSqlParser>>>>
missing 'FUNCTIONS' at 'ON'(line 1, pos 13)

== SQL ==
SHOW DATAMAP ON TABLE lineitem
-------------^^^

CarbonSqlParser>>>> [1.6] failure: identifier matching regex (?i)SEGMENTS expected

SHOW DATAMAP ON TABLE lineitem
     ^ (state=,code=0)
0: jdbc:hive2://10.18.98.34:23040> desc datamap agr_lineitem on table lineitem;
Error: java.lang.RuntimeException:
BaseSqlParser>>>>
mismatched input 'on' expecting {<EOF>, '.'}(line 1, pos 26)

== SQL ==
desc datamap agr_lineitem on table lineitem
--------------------------^^^

CarbonSqlParser>>>> [1.1] failure: identifier matching regex (?i)CREATE expected

desc datamap agr_lineitem on table lineitem
^ (state=,code=0)
0: jdbc:hive2://10.18.98.34:23040> DROP DATAMAP agr_lineitem;
Error: java.lang.RuntimeException:
BaseSqlParser>>>>
no viable alternative at input 'DROP DATAMAP'(line 1, pos 5)

== SQL ==
DROP DATAMAP agr_lineitem
-----^^^

CarbonSqlParser>>>> [1.1] failure: identifier matching regex (?i)CREATE expected

DROP DATAMAP agr_lineitem
^ (state=,code=0)



was (Author: ram@huawei):
Similar issue found in these table operations as well:
As per doc:

> Carbon1.3.0-Pre-AggregateTable - Show datamap  on table <par_table> does not work
> ---------------------------------------------------------------------------------
>
>                 Key: CARBONDATA-1711
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1711
>             Project: CarbonData
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.3.0
>         Environment: Test
>            Reporter: Ramakrishna S
>            Priority: Minor
>             Fix For: 1.3.0
>
>
> 0: jdbc:hive2://10.18.98.34:23040> create datamap agr_lineitem ON TABLE lineitem USING "org.apache.carbondata.datamap.AggregateDataMapHandler" as select L_RETURNFLAG,L_LINESTATUS,sum(L_QUANTITY),sum(L_EXTENDEDPRICE) from lineitem group by  L_RETURNFLAG, L_LINESTATUS;
> Error: java.lang.RuntimeException: Table [lineitem_agr_lineitem] already exists under database [default] (state=,code=0)
> 0: jdbc:hive2://10.18.98.34:23040> show tables;
> +-----------+-----------------------------------+--------------+--+
> | database  |             tableName             | isTemporary  |
> +-----------+-----------------------------------+--------------+--+
> | default   | flow_carbon_test4                 | false        |
> | default   | jl_r3                             | false        |
> | default   | lineitem                          | false        |
> | default   | lineitem_agr_lineitem             | false        |
> | default   | sensor_reading_blockblank_false   | false        |
> | default   | sensor_reading_blockblank_false1  | false        |
> | default   | sensor_reading_blockblank_false2  | false        |
> | default   | sensor_reading_false              | false        |
> | default   | sensor_reading_true               | false        |
> | default   | t1                                | false        |
> | default   | t1_agg_t1                         | false        |
> | default   | tc4                               | false        |
> | default   | uniqdata                          | false        |
> +-----------+-----------------------------------+--------------+--+
> 13 rows selected (0.04 seconds)
> 0: jdbc:hive2://10.18.98.34:23040> show datamap on table lineitem;
> Error: java.lang.RuntimeException:
> BaseSqlParser>>>>
> missing 'FUNCTIONS' at 'on'(line 1, pos 13)
> == SQL ==
> show datamap on table lineitem
> -------------^^^
> CarbonSqlParser>>>> [1.6] failure: identifier matching regex (?i)SEGMENTS expected
> show datamap on table lineitem

--
This message was sent by Atlassian JIRA
(v6.4.14#64029)