This example reconstructs the DWT Example input.
SQL Call
DROP TABLE climate_reconstruct; SELECT * FROM IDWT ( ON dwt_coef_table AS InputTable ON dwt_meta_table AS MetaTable OUT TABLE OutputTable (climate_reconstruct) USING InputColumns ('temp_f', 'pressure_mbar', 'dewpoint_f') SortColumn ('waveletid') PartitionColumns ('city') ) AS dt;
Output
messages |
---|
IDwt finished successfully! |
This query returns the following table:
SELECT * FROM climate_reconstruct ORDER BY city, indexid;
Except for its name, climate_reconstruct, the output table is the same as the DWT Example input table, ville_climatedata. The original values for the temperature, pressure, and the dew point are reconstructed.
city | indexid | temp_f | pressure_mbar | dewpoint_f |
---|---|---|---|---|
Asheville | 1 | 34.9000015258789 | 1020.5 | 28.8999996185303 |
Asheville | 2 | 34.4000015258789 | 1020.20001220703 | 28.7000007629395 |
Asheville | 3 | 33.9000015258789 | 1020 | 28.3999996185303 |
Asheville | 4 | 33.4000015258789 | 1020.20001220703 | 28.2999992370606 |
Asheville | 5 | 33.0999984741211 | 1020.20001220703 | 28 |
Asheville | 6 | 32.7000007629395 | 1020 | 27.8999996185303 |
Asheville | 7 | 32.5 | 1020.29998779297 | 27.7000007629395 |
Asheville | 8 | 32.2999992370606 | 1020.79998779297 | 27.6000003814697 |
Asheville | 9 | 32.0999984741211 | 1021.29998779297 | 27.3999996185303 |
Asheville | 10 | 33.7999992370606 | 1021.70001220703 | 28.2000007629395 |
Asheville | 11 | 36.4000015258789 | 1022.09997558594 | 28.8999996185303 |
Asheville | 12 | 39.4000015258789 | 1022 | 29.2999992370606 |
Asheville | 13 | 42.0999984741211 | 1021.09997558594 | 29.2000007629395 |
Asheville | 14 | 44.2000007629395 | 1020 | 29.1000003814698 |
Asheville | 15 | 45.5999984741211 | 1019.29998779297 | 28.8999996185303 |
Asheville | 16 | 46.2000007629395 | 1019 | 28.5 |
Asheville | 17 | 45.7999992370606 | 1019.20001220703 | 28.5 |
Asheville | 18 | 44.0999984741211 | 1019.59997558594 | 28.6000003814698 |
Asheville | 19 | 41.2000007629395 | 1020.09997558594 | 28.5 |
Asheville | 20 | 39.5999984741211 | 1020.59997558594 | 28.7999992370606 |
Asheville | 21 | 38.2000007629395 | 1020.90002441406 | 29 |
Asheville | 22 | 37.2000007629395 | 1021.09997558594 | 29 |
Asheville | 23 | 36.2999992370606 | 1021 | 29 |
Asheville | 24 | 35.5 | 1020.90002441406 | 29 |
Brownsville | 1 | 35.0999984741211 | 1020.5 | 28.8999996185303 |
Brownsville | 2 | 34.5999984741211 | 1020.20001220703 | 28.7999992370606 |
Brownsville | 3 | 34.0999984741211 | 1020 | 28.5 |
Brownsville | 4 | 33.7000007629395 | 1020.09997558594 | 28.3999996185303 |
Brownsville | 5 | 33.2999992370606 | 1020.20001220703 | 28.2000007629395 |
... | ... | ... | ... | ... |