Chetan Bhat created CARBONDATA-3809:
---------------------------------------
Summary: Refresh index command fails for secondary index as per
syntax mentioned in
https://github.com/apache/carbondata/blob/master/docs/index/secondary-index-guide.md
Key: CARBONDATA-3809
URL: https://issues.apache.org/jira/browse/CARBONDATA-3809
Project: CarbonData
Issue Type: Bug
Components: data-query
Affects Versions: 2.0.0
Environment: Spark 2.3.2, Spark 2.4.5
Reporter: Chetan Bhat
Refresh index command fails for secondary index as per syntax mentioned in
[https://github.com/apache/carbondata/blob/master/docs/index/secondary-index-guide.md]
0: jdbc:hive2://10.20.255.171:23040/default> create table brinjal (imei
string,AMSize string,channelsId string,ActiveCountry string, Activecity
string,gamePointId double,deviceInformationId double,productionDate
Timestamp,deliveryDate timestamp,deliverycharge double) STORED as carbondata
TBLPROPERTIES('table_blocksize'='1');
+---------+--+
| Result |
+---------+--+
+---------+--+
No rows selected (0.218 seconds)
0: jdbc:hive2://10.20.255.171:23040/default> LOAD DATA INPATH
'hdfs://hacluster/chetan/vardhandaterestruct.csv' INTO TABLE brinjal
OPTIONS('DELIMITER'=',', 'QUOTECHAR'=
'"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'=
'imei,deviceInformationId,AMSize,channelsId,ActiveCountry,Activecity,gamePointId,productionDate,deliveryDate,deliverycharge');
+---------+--+
| Result |
+---------+--+
+---------+--+
No rows selected (2.31 seconds)
0: jdbc:hive2://10.20.255.171:23040/default> CREATE INDEX indextable2 ON TABLE
brinjal (AMSize) AS 'carbondata';
+---------+--+
| Result |
+---------+--+
+---------+--+
No rows selected (2.379 seconds)
0: jdbc:hive2://10.20.255.171:23040/default> refresh index indextable2;
Error: org.apache.spark.sql.AnalysisException: == Parser1:
org.apache.spark.sql.parser.CarbonExtensionSpark2SqlParser ==
[1.26] failure: end of input
refresh index indextable2
^;
== Parser2: org.apache.spark.sql.execution.SparkSqlParser ==
REFRESH statements cannot contain ' ', '\n', '\r', '\t' inside unquoted
resource paths(line 1, pos 0)
== SQL ==
refresh index indextable2
^^^; (state=,code=0)
0: jdbc:hive2://10.20.255.171:23040/default> REFRESH INDEX indextable2 WHERE
SEGMENT.ID IN(0);
Error: org.apache.spark.sql.AnalysisException: == Parser1:
org.apache.spark.sql.parser.CarbonExtensionSpark2SqlParser ==
[1.27] failure: identifier matching regex (?i)ON expected
REFRESH INDEX indextable2 WHERE SEGMENT.ID IN(0)
^;
== Parser2: org.apache.spark.sql.execution.SparkSqlParser ==
REFRESH statements cannot contain ' ', '\n', '\r', '\t' inside unquoted
resource paths(line 1, pos 0)
== SQL ==
REFRESH INDEX indextable2 WHERE SEGMENT.ID IN(0)
^^^; (state=,code=0)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
