BIGDECIMAL still needed for comparisons? Errors in SQL Worksheet

Answered

Follow

Rick Pack

• August 01, 2019 17:56

Do we still need to use BIGDECIMAL on numeric variables, at least sometimes, in order to perform comparisons against some numbers, possibly only those with a decimal like 6.4?

We encountered this need for BIGDECIMAL with an older version of Datameer and now it appears the use of BIGDECIMAL triggers an error in a SQL Worksheet.

I unfortunately am not sure what version of Datameer we are using but given the availability of SQL Worksheets, perhaps the version is at least 7? 

0

• 

  Alan

  • August 01, 2019 18:36

  Hi Rick,

  A few things: Not all Datameer functions are available in SQL Worksheets, however it is mostly due to not being required.

  You should be able to do standard SQL comparisons as described here:

  https://documentation.datameer.com/documentation/display/DAS70/SQL+Worksheet#SQLWorksheet-SQLEditorFeatures

  As long as you qualify your result_decimal column, I believe you should just be able to do WHERE sheet.result_decimal > 6.4.

  0

  Comment actions Permalink

Please sign in to leave a comment.