You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@carbondata.apache.org by Swati <sw...@knoldus.com> on 2016/10/28 06:19:20 UTC
List the supported datatypes in carbondata
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.
Re: List the supported datatypes in carbondata
Posted by Liang Chen <ch...@gmail.com>.
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.
--
View this message in context: http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/List-the-supported-datatypes-in-carbondata-tp2419p2755.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at Nabble.com.
Re: List the supported datatypes in carbondata
Posted by Venkata Gollamudi <g....@gmail.com>.
Hi Ravi,
We can create a Jira and track this.
Regards,
Ramana
On Sat, Nov 5, 2016 at 7:36 AM, Ravindra Pesala <ra...@gmail.com>
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 <26...@qq.com> 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.
> >
>
Re: List the supported datatypes in carbondata
Posted by Ravindra Pesala <ra...@gmail.com>.
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 <26...@qq.com> 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.
>
Re: List the supported datatypes in carbondata
Posted by cenyuhai <26...@qq.com>.
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.
Re: List the supported datatypes in carbondata
Posted by Pallavi Singh <pa...@knoldus.in>.
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 <ra...@gmail.com>
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 <sw...@knoldus.com> 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
pallavi.singh@knoldus.in
+91-9911235949
Re: List the supported datatypes in carbondata
Posted by Ravindra Pesala <ra...@gmail.com>.
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 <sw...@knoldus.com> 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