1.0 - 8.00 - IDWT2D Example - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

This example reconstructs the DWT2D Example input table.

Input

Input tables are DWT2D Example output:

  • InputTable: dwt_coef_table
  • MetaTable: dwt_meta_table

SQL Call

SELECT * FROM IDWT2D (
  ON dwt2d_coeftable AS InputTable
  ON dwt2d_metatable AS MetaTable
  OUT TABLE OutputTable (climate2d_reconstruct)
  USING
  InputColumns ('temp_f', 'pressure_mbar', 'dewpoint_f')
  SortColumn ('waveletid')
  PartitionColumns ('state')
) AS dt;

Output

messages
IDwt2D finished successfully!

This query returns the following table:

SELECT * FROM climate2d_reconstruct ORDER BY state;
climate2d_reconstruct
state indexxy indexxx temp_f pressure_mbar dewpoint_f
CA 32 -117 34.9000015258789 1020.5 28.8999996185303
CA 32 -116 34.4000015258789 1020.20001220703 28.7000007629395
CA 33 -118 33.9000015258789 1020 28.3999996185303
CA 33 -117 33.4000015258789 1020.20001220703 28.2999992370606
CA 34 -121 33.0999984741211 1020.20001220703 28
CA 34 -120 32.7000007629395 1020 27.8999996185303
CA 34 -119 32.5 1020.29998779297 27.7000007629395
CA 34 -118 32.2999992370606 1020.79998779297 27.6000003814698
CA 35 -120 32.0999984741211 1021.29998779297 27.3999996185303
CA 35 -119 33.7999992370606 1021.70001220703 28.2000007629395
CA 35 -118 36.4000015258789 1022.09997558594 28.8999996185303
CA 35 -117 39.4000015258789 1022 29.2999992370606
CA 36 -122 34.9000015258789 1020.5 28.8999996185303
CA 36 -121 34.4000015258789 1020.20001220703 28.7000007629395
CA 36 -120 33.9000015258789 1020 28.3999996185303
CA 36 -119 33.4000015258789 1020.20001220703 28.2999992370606
CA 36 -118 33.0999984741211 1020.20001220703 28
CA 37 -123 32.7000007629395 1020 27.8999996185303
... ... ... ... ... ...
VerboseFlag is 'true' by default; therefore, rows in which all coefficient values have an absolute value less than 1e-12 do not appear in climate2d_reconstruct.