Anurag Srivastava created CARBONDATA-649:

             Summary: Rand() function is not working while updating data
                 Key: CARBONDATA-649
             Project: CarbonData
          Issue Type: Bug
          Components: data-query
    Affects Versions: 1.0.0-incubating
         Environment: Spark 1.6
            Reporter: Anurag Srivastava
            Priority: Minor

I am using update functionality with the *rand(1)* and *rand()* which return 
deterministic value or random value.

But as I run query it gives error.

*Create Table :* CREATE TABLE uniqdata_date_dictionary (CUST_ID int,CUST_NAME 
string,ACTIVE_EMUI_VERSION string, DOB date, DOJ date, BIGINT_COLUMN1 
bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 
decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 
int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES ("TABLE_BLOCKSIZE"= 

*Load Data :* LOAD DATA INPATH 'hdfs://localhost:54310/2000_UniqData.csv' into 
table uniqdata OPTIONS ('DELIMITER'=',' 

*Query-1 :* Update uniqdata  set (decimal_column1) = (rand());

*Query-2 :* Update uniqdata  set (decimal_column1) = (rand(1));
Expected Result : Table created.

Actual Result : Error: 
DICTIONARY_EXCLUDE is unsupported for date data type column: dob (state=,code=0)

This message was sent by Atlassian JIRA

Reply via email to