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.

[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

[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]
[phone]

[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.

[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.
>

[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.
> >
>

[Liang Chen]

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.