nPath Resultの例: ヒンディー語入力ACCUMULATE FIRST_NOTNULL - Advanced SQL Engine - Teradata Database

入力

この例には、ヒンディー語の文字を含む2つの入力テーブルがあります。

SQL呼び出し

SELECT * FROM nPath (
  ON "हिंदी टेबल" PARTITION BY "सत्र आईडी" ORDER BY "क्लिक करें"
  ON "विज्ञापन" DIMENSION ORDER BY "रिले समय"
  USING
  Mode (NONOVERLAPPING)
  Pattern ('^(X|A)+.C')
  Symbols ( "पेज का प्रकार" IS NULL OR "पेज का प्रकार" IS NOT NULL AS X,
    "पेज का प्रकार" = 'चेक आउट' AS C,
    "विज्ञापन" IS NULL OR "विज्ञापन" IS NOT NULL AS A
  )
  Result (
    ACCUMULATE ("रेफरर" of ANY(X)) AS "रेफरल पथ" ,
    FIRST_NOTNULL ("सत्र आईडी"of ANY(X)) AS "सत्र आईडी"
  )
) AS dt;

出力