You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Chetan Bhat (JIRA)" <ji...@apache.org> on 2018/07/11 12:28:00 UTC

[jira] [Created] (CARBONDATA-2728) Concurrent select query when executed on table after set search mode enabled throws divide by zero exception

Chetan Bhat created CARBONDATA-2728:
---------------------------------------

             Summary: Concurrent select query when executed on table after set search mode enabled throws divide by zero exception
                 Key: CARBONDATA-2728
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2728
             Project: CarbonData
          Issue Type: Bug
          Components: data-query
    Affects Versions: 1.4.1
         Environment: Spark 2.1
            Reporter: Chetan Bhat


Steps :

From Beeline user executes the set carbon.search.enabled=true;

User Creates table and load data.

create table Test_Boundary (c1_int int,c2_Bigint Bigint,c3_Decimal Decimal(38,38),c4_double double,c5_string string,c6_Timestamp Timestamp,c7_Datatype_Desc string) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('table_blocksize'='512','local_dictionary_enable'='true','local_dictionary_threshold'='1','local_dictionary_include'='c5_string');
LOAD DATA INPATH 'hdfs://hacluster/chetan/Test_Data1.csv' INTO table Test_Boundary OPTIONS('DELIMITER'=',','QUOTECHAR'='','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='');

From 5 concurrent Beeline sessions user executes the select query.

select c3_Decimal from test_boundary where round(c3_Decimal,1) is NULL;

 

Actual Output - Concurrent select query when executed on table after set search mode enabled throws divide by zero exception

0: jdbc:hive2://10.18.98.101:22550/default> select c3_Decimal from test_boundary where round(c3_Decimal,1) is NULL;
Error: java.lang.ArithmeticException: / by zero (state=,code=0)

 

Expected output - The concurrent select query after set search mode enabled should be successful.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)