Page 1 of 1

ERROR 2826 when querying configuration_parameters

Posted: Thu Apr 24, 2014 2:55 pm
by Josh
Anyone know why I might be getting this weird error?

Code: Select all

dbadmin=> select * from configuration_parameters where default_value = 1;
ERROR 2826:  Could not convert "/opt/vertica/log/annotatedExplainSQL.sql" from column cp.default_value to a float8
I am using Vertica 7.0.1 on a DEV box...

Re: ERROR 2826 when querying configuration_parameters

Posted: Thu Apr 24, 2014 2:59 pm
by NorbertKrupa
Probably because the default_value column is a varchar:

Code: Select all

dbadmin=> SELECT column_name, data_type FROM system_columns WHERE table_name = 'configuration_parameters' ORDER BY ordinal_position;
          column_name          |   data_type
-------------------------------+---------------
 node_name                     | varchar(128)
 parameter_name                | varchar(128)
 current_value                 | varchar(8192)
 default_value                 | varchar(8192)
 change_under_support_guidance | boolean
 change_requires_restart       | boolean
 description                   | varchar(8192)
This works:

Code: Select all

select * from configuration_parameters where default_value = '1';

Re: ERROR 2826 when querying configuration_parameters

Posted: Thu Apr 24, 2014 3:38 pm
by Josh
Thanks, norbertk, that is what I figured... But I wonder if showing that SQL file as part of the error is a bug? Shouldn't the error be similar to the one shown on a normal user table?

Code: Select all

dbadmin=> create table test (t varchar(1));
CREATE TABLE
dbadmin=> insert into test values ('A');
 OUTPUT
--------
      1
(1 row)

dbadmin=> select * from test where t = 1;
ERROR 2826:  Could not convert "A" from column test.t to a float8
Or maybe not :?: No biggie :roll:

Re: ERROR 2826 when querying configuration_parameters

Posted: Thu Apr 24, 2014 4:47 pm
by NorbertKrupa
May be a bug 8-)

Code: Select all

-- Vertica Analytic Database v7.0.1-0
dbadmin=> SELECT * FROM configuration_parameters WHERE default_value = 1;
ERROR 2826:  Could not convert "/opt/vertica/log/annotatedExplainSQL.sql" from column cp.default_value to a float8

-- Vertica Analytic Database v6.1.2-0
dbadmin=> SELECT * FROM configuration_parameters WHERE default_value = 1;
ERROR 2826:  Could not convert "" from column cp.default_value to a float8

-- Vertica Analytic Database v6.0.1-0
dbadmin=> SELECT * FROM configuration_parameters WHERE default_value = 1;
ERROR 2826:  Could not convert "" from column cp.default_value to a float8
I reported it on the Vertica Community.

Re: ERROR 2826 when querying configuration_parameters

Posted: Fri Apr 25, 2014 3:35 pm
by id10t
Hi!

[DELETED]

Re: ERROR 2826 when querying configuration_parameters

Posted: Fri Apr 25, 2014 3:39 pm
by NorbertKrupa
sKwa wrote:Will see if will be any movement.
I will be pleasantly surprised.