17.10 - TD_FunctionTransformの例 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine分析関数

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
2021年7月
Content Type
プログラミング リファレンス
Publication ID
B035-1206-171K-JPN
Language
日本語 (日本)

入力

SQL呼び出し

SELECT * FROM TD_FunctionTransform (
  ON function_input_table AS InputTable
  ON fit_out AS FitTable DIMENSION
  USING
  IDColumns ('[0:2]','[6:7]')
) AS dt ORDER BY Passenger;

出力

passenger     survived       pclass  name                                                                                        sex                            age        sibsp        parch  ticket                                  fare  cabin                 embarked
-----------  -----------  -----------  ------------------------------------------------------------------------------------------  ----------  ----------------------  -----------  -----------  --------------------  ----------------------  --------------------  ----------
          1            0            3  Braund; Mr. Owen Harris                                                                     male         4.45943161863730E 000            1            0  A/5 21171              5.25625000000000E 001                        S
          2            1            1  Cumings; Mrs. John Bradley (Florence Briggs Thayer)                                         female       5.24792751344359E 000            1            0  PC 17599               5.08130885889000E 003  C85                   C
          3            1            3  Heikkinen; Miss. Laina                                                                      female       4.70043971814109E 000            0            0  STON/O2. 3101282       6.28056250000000E 001                        S
          4            1            1  Futrelle; Mrs. Jacques Heath (Lily May Peel)                                                female       5.12928301694497E 000            1            0  113803                 2.81961000000000E 003  C123                  S
          5            0            3  Allen; Mr. William Henry                                                                    male         5.12928301694497E 000            0            0  373450                 6.48025000000000E 001                        S