Create table with columns contains spaces in name.

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Create table with columns contains spaces in name.

Harmeet Singh
I want to create table, using columns that contains spaces. I am using Thrift Server and Beeline client for accessing carbon data. Whenever i am trying to create a table, and their columns name contains spaces i am getting an error. Below are the steps:

Step 1:
create table three (`first name` string, `age` int) stored by 'carbondata';

Whenever i am executing above query, i am getting below error:
Error: org.apache.carbondata.spark.exception.MalformedCarbonCommandException: Unsupported data type : FieldSchema(name:first name, type:string, comment:null).getType (state=,code=0)

The above error is pretending to be wrong data types are using.

If am going to remove `stored by 'carbondata'` on query, this will work fine.

Please confirm this is an issue of carbon data or carbon data is not support column name with spaces ?
Reply | Threaded
Open this post in threaded view
|

Re: Create table with columns contains spaces in name.

ravipesala
Probably it is a bug.
Reply | Threaded
Open this post in threaded view
|

Re: Create table with columns contains spaces in name.

Harmeet Singh
Thanks ravi, I will be raise on Jira.
Reply | Threaded
Open this post in threaded view
|

Re: Create table with columns contains spaces in name.

Liang Chen
Administrator
Hi Harmeet

Thank you reported this issue.

Would you like to fix this issue?

Regards
Liang

Harmeet Singh wrote
Thanks ravi, I will be raise on Jira.
Reply | Threaded
Open this post in threaded view
|

Re: Create table with columns contains spaces in name.

Harmeet Singh
Hey Liang,

Sure I will be fix that issue.