[jira] [Created] (CARBONDATA-3809) 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

[Akash R Nilugal (Jira)]

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)