> 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
> Priority: Major
> Fix For: 2.0.0
>
>
> 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)
Locked
