You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Vandana Yadav (JIRA)" <ji...@apache.org> on 2018/02/27 08:17:00 UTC

[jira] [Updated] (CARBONDATA-2205) Unable to create a table with char data type with Spark 2.2.1

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

Vandana Yadav updated CARBONDATA-2205:
--------------------------------------
    Description: 
Unable to create a table with char data type with Spark 2.2.1

Steps to reproduce:

1) create a table with char data type:

 CREATE TABLE uniqdata_char(id char) partitioned by (name char) stored by 'carbondata';

Expected Result: Table should be created successfully.

Actual Result: 

Error: org.apache.spark.sql.AnalysisException: == Parse1 ==

DataType char is not supported.(line 1, pos 30)

== SQL ==
CREATE TABLE uniqdata_char(id char) partitioned by (name char) stored by 'carbondata'
------------------------------^^^

== Parse2 ==
 [1.8] failure: identifier matching regex (?i)DATAMAP expected

CREATE TABLE uniqdata_char(id char) partitioned by (name char) stored by 'carbondata'
^;; (state=,code=0)

 

Note: Creating a table with char data type we don't need to provide any size with spark 2.1.0, but in spark 2.2.1 it's throwing a parsing error but when we provide size with char data type it lets us create a table successfully, we need to update this syntactical error in our documentation for reference.

  was:
Unable to create a table with char data type with Spark 2.2.1

Steps to reproduce:

1) create a table with char data type:

 CREATE TABLE uniqdata_char(id char) partitioned by (name char) stored by 'carbondata';

Expected Result: Table should be created successfully.

Actual Result: 

Error: org.apache.spark.sql.AnalysisException: == Parse1 ==

DataType char is not supported.(line 1, pos 30)

== SQL ==
CREATE TABLE uniqdata_char(id char) partitioned by (name char) stored by 'carbondata'
------------------------------^^^

== Parse2 ==
[1.8] failure: identifier matching regex (?i)DATAMAP expected

CREATE TABLE uniqdata_char(id char) partitioned by (name char) stored by 'carbondata'
 ^;; (state=,code=0)


> Unable to create a table with char data type with Spark 2.2.1
> -------------------------------------------------------------
>
>                 Key: CARBONDATA-2205
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2205
>             Project: CarbonData
>          Issue Type: Bug
>          Components: data-query
>    Affects Versions: 1.4.0
>            Reporter: Vandana Yadav
>            Priority: Minor
>
> Unable to create a table with char data type with Spark 2.2.1
> Steps to reproduce:
> 1) create a table with char data type:
>  CREATE TABLE uniqdata_char(id char) partitioned by (name char) stored by 'carbondata';
> Expected Result: Table should be created successfully.
> Actual Result: 
> Error: org.apache.spark.sql.AnalysisException: == Parse1 ==
> DataType char is not supported.(line 1, pos 30)
> == SQL ==
> CREATE TABLE uniqdata_char(id char) partitioned by (name char) stored by 'carbondata'
> ------------------------------^^^
> == Parse2 ==
>  [1.8] failure: identifier matching regex (?i)DATAMAP expected
> CREATE TABLE uniqdata_char(id char) partitioned by (name char) stored by 'carbondata'
> ^;; (state=,code=0)
>  
> Note: Creating a table with char data type we don't need to provide any size with spark 2.1.0, but in spark 2.2.1 it's throwing a parsing error but when we provide size with char data type it lets us create a table successfully, we need to update this syntactical error in our documentation for reference.



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