[ 
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:58 AM:
---------------------------------------------------------------------

Similar issue found in these table operations as well:
As per doc:


was (Author: ram@huawei):
Similar issue found in other table operations as well:

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

Reply via email to