Hi Sreejith,

Potentially the query SELECT SUM(DISTINCT COLUMN_NAME) FROM TABLE_NAME returns a column of datatype hge, which is an 128-bit integer.

We currently do not yet support this in the ODBC driver, see also https://www.monetdb.org/bugzilla/show_bug.cgi?id=4002

You can try to cast the value to a bigint in your query as in:

  SELECT CAST(SUM(DISTINCT COLUMN_NAME) AS BIGINT) as count FROM TABLE_NAME

and see of it works.

regards,

Martin vD

Hi Stefan,

 

Did you got a chance to look at below?

 

Do you recommend any specific compiler? Or what could have caused below error?

typeODBC: SQL_UNKNOWN_TYPE mDataType: HG_NULL_VALUE(hgColumnType) precision: 0 scale: 0 nullable: true Column name: L6.

Regards,

Sreejith

 

From: users-list [mailto:users-list-bounces+sreejith.sharma=harman.com@monetdb.org] On Behalf Of Sharma, Sreejith
Sent: Monday, January 01, 2018 10:26 PM
To: Communication channel for MonetDB users <users-list@monetdb.org>
Subject: [EXTERNAL] RE: MonetDB header Datatype Question

 

Hi Stefan,

 

Here are the details you had asked for. Any help here soon is appreciated.

 

What's the (SQL-)type of your column COLUMN_NAME? –

INTEGER

 

Which version of MonetDB are you using? –

MonetDB 5 server v11.27.9 "Jul2017-SP2" (64-bit, 128-bit integers)

 

Which version of the MonetDB ODBC driver are you using?

ODBC Driver - /usr/lib64/libMonetODBC.so (11.27.9 and tried 11.27.5 updated)

 

Which compiler did you use to compile MonetDB on which OS?

configure:5030: checking for C compiler version

configure:5039: gcc --version >&5

gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16)

 

#define PACKAGE_NAME "MonetDB"

| #define PACKAGE_TARNAME "MonetDB"

| #define PACKAGE_VERSION "11.27.9"

| #define PACKAGE_STRING "MonetDB 11.27.9"

| #define PACKAGE_BUGREPORT "https://clicktime.symantec.com/a/1/XvlE0Nrai7nkDv-7kcWL-frL1Py4pp8L5Fwiuss-GGU=?d=nDm1_wY4jvkJLNellZbkkr5IvoHfbpfoDpykA5-mglvrRM-EZi8dtl08ub2TDaGEe3elqtX0wZT7k5S3EGqvL32XIPqSk65UFg0RMfDA9rVlJZlLDiP_ymCNZXMa1wIZVKNT0alOvI4VQQySEuneyGipFUpplRC4XNMj81Rfc0zBiyVgvxHYYqV_z1JucAMh8MSGiDLPQVGnC3Vf6s9L6dTvds2aRQW0sn9eS7UGrxeSs8kI-pjOC_kuwOZZxUy_tc9k3sbbXfUgB348Degf9HEXM_120TB5s3DaiHeiDjdEiZtkbTjCbSjL6n4lgQ0s08D4rFjfhUoXCjtxLj_opwZ0-m7NTQgztksOZfJ-AfvqQ80T2uSf-2X5Tit0IYCG-Zuf7AEP6CT2fbLhlG0t0PHBWR9k_uG1HGG4_8YfjhVhHlkwqNL1K7nZuNH_&u=https%3A%2F%2Fbugs.monetdb.org%2F%26quot%3B

| #define PACKAGE_URL "https://clicktime.symantec.com/a/1/lZxPBgh8Mb2IQtVgmE-0-jCaZv2MRPyKcO0i1KCYomI=?d=nDm1_wY4jvkJLNellZbkkr5IvoHfbpfoDpykA5-mglvrRM-EZi8dtl08ub2TDaGEe3elqtX0wZT7k5S3EGqvL32XIPqSk65UFg0RMfDA9rVlJZlLDiP_ymCNZXMa1wIZVKNT0alOvI4VQQySEuneyGipFUpplRC4XNMj81Rfc0zBiyVgvxHYYqV_z1JucAMh8MSGiDLPQVGnC3Vf6s9L6dTvds2aRQW0sn9eS7UGrxeSs8kI-pjOC_kuwOZZxUy_tc9k3sbbXfUgB348Degf9HEXM_120TB5s3DaiHeiDjdEiZtkbTjCbSjL6n4lgQ0s08D4rFjfhUoXCjtxLj_opwZ0-m7NTQgztksOZfJ-AfvqQ80T2uSf-2X5Tit0IYCG-Zuf7AEP6CT2fbLhlG0t0PHBWR9k_uG1HGG4_8YfjhVhHlkwqNL1K7nZuNH_&u=https%3A%2F%2Fwww.monetdb.org%2F%26quot%3B

| #define PACKAGE "MonetDB"

| #define VERSION "11.27.9"

| #define HOST "x86_64-pc-linux-gnu"

| #define MONETDB_RELEASE "Jul2017-SP2"

 

What did configure say about what the largest supported integer type is?

                hge_bits='128'

largest integer type: ${hge_bits} bits"

 

 

Regards,

Sreejith

 

From: users-list [mailto:users-list-bounces+sreejith.sharma=harman.com@monetdb.org] On Behalf Of Stefan Manegold
Sent: Monday, January 01, 2018 7:05 AM
To: Communication channel for MonetDB users <users-list@monetdb.org>
Subject: [EXTERNAL] Re: MonetDB header Datatype Question

 

 

What's the (SQL-)type of your column COLUMN_NAME?

Which version of MonetDB are you using?

Which version of the MonetDB ODBC driver are you using?

Which compiler did you use to compile MonetDB on which OS?

What did configure say about what the largest supported integer type is?

 

 

-------- Original message --------

From: "Sharma, Sreejith" <Sreejith.Sharma@harman.com>

Date: 12/31/17 18:33 (GMT+01:00)

To: users-list@monetdb.org

Subject: RE: MonetDB header Datatype Question

 

All,

 

Here is the specifics of error –

 

typeODBC: SQL_UNKNOWN_TYPE mDataType: HG_NULL_VALUE(hgColumnType) precision: 0 scale: 0 nullable: true Column name: L6.

 

Regards,

Sreejith

 

From: Sharma, Sreejith
Sent: Sunday, December 31, 2017 11:21 AM
To: users-list@monetdb.org
Subject: MonetDB header Datatype Question

 

All,

 

I would like to know what is the MonetDB header datatype if no alias or column name provided? In my BI application, am getting an error while using SELECT SUM(DISTINCT COLUMN_NAME) FROM TABLE_NAME. I see it works in 11.27.9 build when installed in CentOS. However, when i download the source tarball and recompile the code, this fox seems to be lost. Is there anywhere this can be identified? Or fixed?

Regards,

Sreejith

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list