carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ravindra Pesala (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CARBONDATA-698) no_inverted_index is not working
Date Wed, 10 May 2017 07:41:04 GMT

     [ https://issues.apache.org/jira/browse/CARBONDATA-698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Ravindra Pesala resolved CARBONDATA-698.
----------------------------------------
    Resolution: Duplicate

> no_inverted_index is not working
> --------------------------------
>
>                 Key: CARBONDATA-698
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-698
>             Project: CarbonData
>          Issue Type: Bug
>          Components: spark-integration
>    Affects Versions: 1.0.0-incubating
>         Environment: spark1.6,2.1
>            Reporter: anubhav tarar
>            Assignee: anubhav tarar
>            Priority: Trivial
>          Time Spent: 1.5h
>  Remaining Estimate: 0h
>
> i am creating no_inverted_index with invalid values using both spark 1.6 and 2.1 and
it works 
> spark 2.1 logs
> 0: jdbc:hive2://localhost:10000> DROP TABLE IF EXISTS  productSalesTable;
> +---------+--+
> | Result  |
> +---------+--+
> +---------+--+
> No rows selected (3.621 seconds)
> 0: jdbc:hive2://localhost:10000>   CREATE TABLE productSalesTable( productNumber Int,
productName String, storeCity String, storeProvince String, productCategory String, productBatch
String, saleQuantity Int, revenue Int) STORED BY 'carbondata' TBLPROPERTIES ('COLUMN_GROUPS'='(
productName)','DICTIONARY_INCLUDE'='productName', 'NO_INVERTED_INDEX'='1');
> spark 1.6 logs
> cc.sql("DROP TABLE IF EXISTS  productSalesTable").show();
>     cc.sql("""CREATE TABLE productSalesTable( productNumber Int, productName String,
storeCity String, storeProvince String, productCategory String, productBatch String, saleQuantity
Int, revenue Int) STORED BY 'carbondata' TBLPROPERTIES ('COLUMN_GROUPS'='( productName)','DICTIONARY_INCLUDE'='productName',
'NO_INVERTED_INDEX'='1')""").show()
> AUDIT 07-02 15:48:14,485 - [knoldus][knoldus][Thread-1]Creating Table with Database name
[default] and Table name [productsalestable]
> AUDIT 07-02 15:48:14,868 - [knoldus][knoldus][Thread-1]Table created with Database name
[default] and Table name [productsalestable]
> while debugging the code i found out in carbon ddl sql parser tablePropertiess map contain
the properties in lower case
> and we are checking tableProperties.get("NO_INVERTED_INDEX")
> so it is failing due to string mismatch



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message