List the supported datatypes in carbondata

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

List the supported datatypes in carbondata

Swati
Hi,

I would like to know about the datatypes which are supported by carbondata as I am getting this error "MalformedCarbonCommandException:  Unsupported data type" while running the queries against these datatypes :" tiny Int, smallInt, float, date, varchar, char, boolean, binary, Map, Union ". Also there is no information available in the documentation about supported datatypes.
Reply | Threaded
Open this post in threaded view
|

Re: List the supported datatypes in carbondata

ravipesala
Hi,

Following are the supported datatypes in carbon.
string,int,
integer,tinyint,short,long,bigint,numeric,double,decimal,timestamp,array,struct.

Regards,
Ravi

On 28 October 2016 at 11:49, Swati <[hidden email]> wrote:

> Hi,
>
> I would like to know about the datatypes which are supported by carbondata
> as I am getting this error *"MalformedCarbonCommandException:  Unsupported
> data type"* while running the queries against these datatypes :*" tiny Int,
> smallInt, float, date, varchar, char, boolean, binary, Map, Union "*. Also
> there is no information available in the documentation about supported
> datatypes.
>
>
>
> --
> View this message in context: http://apache-carbondata-
> mailing-list-archive.1130556.n5.nabble.com/List-the-
> supported-datatypes-in-carbondata-tp2419.html
> Sent from the Apache CarbonData Mailing List archive mailing list archive
> at Nabble.com.
>



--
Thanks & Regards,
Ravi
Reply | Threaded
Open this post in threaded view
|

Re: List the supported datatypes in carbondata

Pallavi Singh
As per the previous conversation reply :
Following are the supported datatypes in carbon.
string,int,
integer,tinyint,short,long,bigint,numeric,double,decimal,
timestamp,array,struct.

Could you please clarify if both int and Integer should be supported ?

Using Integer datatype is giving me following error

0: jdbc:hive2://localhost:10000> create table emp(id Integer, name String)
stored by 'carbondata';
Error: org.apache.spark.sql.AnalysisException: cannot recognize input near
'Integer' ',' 'name' in column type; line 1 pos 20 (state=,code=0)

On Sat, Oct 29, 2016 at 7:11 AM, Ravindra Pesala <[hidden email]>
wrote:

> Hi,
>
> Following are the supported datatypes in carbon.
> string,int,
> integer,tinyint,short,long,bigint,numeric,double,decimal,
> timestamp,array,struct.
>
> Regards,
> Ravi
>
> On 28 October 2016 at 11:49, Swati <[hidden email]> wrote:
>
> > Hi,
> >
> > I would like to know about the datatypes which are supported by
> carbondata
> > as I am getting this error *"MalformedCarbonCommandException:
> Unsupported
> > data type"* while running the queries against these datatypes :*" tiny
> Int,
> > smallInt, float, date, varchar, char, boolean, binary, Map, Union "*.
> Also
> > there is no information available in the documentation about supported
> > datatypes.
> >
> >
> >
> > --
> > View this message in context: http://apache-carbondata-
> > mailing-list-archive.1130556.n5.nabble.com/List-the-
> > supported-datatypes-in-carbondata-tp2419.html
> > Sent from the Apache CarbonData Mailing List archive mailing list archive
> > at Nabble.com.
> >
>
>
>
> --
> Thanks & Regards,
> Ravi
>



--
Regards | Pallavi Singh
Software Consultant
Knoldus Software LLP
[hidden email]
+91-9911235949
Reply | Threaded
Open this post in threaded view
|

Re: List the supported datatypes in carbondata

cenyuhai
I think we should make it clear that what datatypes are supported in carbondata.

these types are confused (int or integer, short or smallint, long or bigint, double or numeric)

some datatypes are not supported now, (numeric, integer, short, smallint, long, numeric).

We should tell users what datatypes are supported in docs which is not existed now.

We need a doc like https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types

I suggest that we support (string, int, smallint, bigint, float, double, decimal, timestamp, array, struct) at first.
Reply | Threaded
Open this post in threaded view
|

Re: List the supported datatypes in carbondata

ravipesala
Yes,. We need to have a document with the supported datatypes of carbon
data. We listed this gap and working towards it.

The following are datatypes we should support now. We better follow the
datatypes syntax supported by hive as we use there parser.

 (string, int/integer, smallint, bigint, float, double,
decimal, timestamp, array, struct)

On Sat, Nov 5, 2016, 6:16 AM cenyuhai <[hidden email]> wrote:

> I think we should make it clear that what datatypes are supported in
> carbondata.
>
> these types are confused (int or integer, short or smallint, long or
> bigint,
> double or numeric)
>
> some datatypes are not supported now, (numeric, integer, short, smallint,
> long, numeric).
>
> We should tell users what datatypes are supported in docs which is not
> existed now.
>
> We need a doc like
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types
>
> I suggest that we support (string, int, smallint, bigint, float, double,
> decimal, timestamp, array, struct) at first.
>
>
>
>
> --
> View this message in context:
> http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/List-the-supported-datatypes-in-carbondata-tp2419p2659.html
> Sent from the Apache CarbonData Mailing List archive mailing list archive
> at Nabble.com.
>
Reply | Threaded
Open this post in threaded view
|

Re: List the supported datatypes in carbondata

Venkata Gollamudi
Hi Ravi,

We can create a Jira and track this.

Regards,
Ramana

On Sat, Nov 5, 2016 at 7:36 AM, Ravindra Pesala <[hidden email]>
wrote:

> Yes,. We need to have a document with the supported datatypes of carbon
> data. We listed this gap and working towards it.
>
> The following are datatypes we should support now. We better follow the
> datatypes syntax supported by hive as we use there parser.
>
>  (string, int/integer, smallint, bigint, float, double,
> decimal, timestamp, array, struct)
>
> On Sat, Nov 5, 2016, 6:16 AM cenyuhai <[hidden email]> wrote:
>
> > I think we should make it clear that what datatypes are supported in
> > carbondata.
> >
> > these types are confused (int or integer, short or smallint, long or
> > bigint,
> > double or numeric)
> >
> > some datatypes are not supported now, (numeric, integer, short, smallint,
> > long, numeric).
> >
> > We should tell users what datatypes are supported in docs which is not
> > existed now.
> >
> > We need a doc like
> > https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types
> >
> > I suggest that we support (string, int, smallint, bigint, float, double,
> > decimal, timestamp, array, struct) at first.
> >
> >
> >
> >
> > --
> > View this message in context:
> > http://apache-carbondata-mailing-list-archive.1130556.
> n5.nabble.com/List-the-supported-datatypes-in-carbondata-tp2419p2659.html
> > Sent from the Apache CarbonData Mailing List archive mailing list archive
> > at Nabble.com.
> >
>
Reply | Threaded
Open this post in threaded view
|

Re: List the supported datatypes in carbondata

Liang Chen
Administrator
In reply to this post by cenyuhai
Hi

Please find the data type list:
https://cwiki.apache.org/confluence/display/CARBONDATA/Carbon+Data+Types

Regards
Liang
cenyuhai wrote
I think we should make it clear that what datatypes are supported in carbondata.

these types are confused (int or integer, short or smallint, long or bigint, double or numeric)

some datatypes are not supported now, (numeric, integer, short, smallint, long, numeric).

We should tell users what datatypes are supported in docs which is not existed now.

We need a doc like https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types

I suggest that we support (string, int, smallint, bigint, float, double, decimal, timestamp, array, struct) at first.