[CARBONDATA-1711] Carbon1.3.0-DataMap - Show datamap on table <par_table> does not work

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.3.0
• Fix Version/s: 1.3.0
• Component/s: core
• Labels: Functional
• Environment: Test
• Assignee: anubhav tarar
• Reporter: Ramakrishna S
• Created: 14/Nov/17 13:43
• Updated: 20/Dec/17 13:57
• Resolved: 20/Dec/17 13:57

Description

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