Input
- Input table: ville_temperature, as in Pack_MLE Example: Default Values
SQL Call
Delimiter and IncludeColumnName have nondefault values.
SELECT row_id, cast(packed_data as varchar(100)), sn
FROM Pack_MLE(
ON ville_temperature
USING
Delimiter('|')
OutputColumn('packed_data')
IncludeColumnName('false')
TargetColumns('city', 'state', 'period', 'temp_F')
) as dt ORDER BY sn;
Output
Virtual columns are separated by pipe characters and not labeled with their column names.
row_id packed_data sn
------ -------------------------------------------- --
5 nashville|tennessee|2010-01-01 00:00:00|35.1 1
7 nashville|tennessee|2010-01-01 01:00:00|36.2 2
4 nashville|tennessee|2010-01-01 02:00:00|34.5 3
2 nashville|tennessee|2010-01-01 03:00:00|33.6 4
3 nashville|tennessee|2010-01-01 04:00:00|33.1 5
3 knoxville|tennessee|2010-01-01 03:00:00|33.2 6
1 knoxville|tennessee|2010-01-01 04:00:00|32.8 7
6 knoxville|tennessee|2010-01-01 05:00:00|32.4 8
1 knoxville|tennessee|2010-01-01 06:00:00|32.2 9
2 knoxville|tennessee|2010-01-01 07:00:00|32.4 10
Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.