I'm getting the "SELECT Failed. 3706: Syntax error: Data Type "response_tm_sec" does not match a Defined Type name." error when I run the following SQL on SQL Assistant:
select min(response_tm_sec) min_response_tm
, average(response_tm_sec) avg_response_tm
, max(response_tm_sec) max_response_tm
--, stdev(response_tm_sec) stdev_response_tm
where response_tm_sec is not null
However, if I comment the stdev line, the query works and gives me a result for max, min and averages. The response_tms_sec is a decimal type (18,8). It shows up like this with the help command:
|Column Name||Type||Nullable||Format||Max Length||Decimal Total Digits||Decimal Fractional Digits|
I get this column b extract the hour, minute and seconds(with 6 fractional digits) out of an interval type and multiplying and adding to get the figure in seconds.
I saw on another post that this may have to do with ODBC functions. I went into Tools -> Options -> Query to "Allow ODBC Functions" but no such options was present.
I use Teradata Database Version 13.10.0509 13.10.05.09 and Provider Version ODBC 13.10.00.06 and Client 13.10
I did do a bit of search about this kind of error but none of the options I came upon dealt with tis problem happening with decimal data types and the solutions didn't work.
Thanks in advance for your help
The error message is misleading, there's no stdev function, it's called STDDEV_POP or STDDEV_SAMP :-)