Realtime Compute for Apache Flink:PARSE_URL

VARCHAR PARSE_URL(VARCHAR urlStr, VARCHAR partToExtract [, VARCHAR key])

partToExtract için geçerli değerler

SELECT PARSE_URL(url1, 'QUERY', 'query') AS var1,  -- returns '1'
       PARSE_URL(url1, 'QUERY')          AS var2,  -- returns 'query=1'
       PARSE_URL(url1, 'HOST')           AS var3,  -- returns 'facebook.com'
       PARSE_URL(url1, 'PATH')           AS var4,  -- returns '/path/p1.php'
       PARSE_URL(url1, 'REF')            AS var5,  -- returns NULL (no fragment)
       PARSE_URL(url1, 'PROTOCOL')       AS var6,  -- returns 'http'
       PARSE_URL(url1, 'FILE')           AS var7,  -- returns '/path/p1.php?query=1'
       PARSE_URL(url1, 'AUTHORITY')      AS var8,  -- returns 'facebook.com'
       PARSE_URL(url1, 'USERINFO')       AS var9,  -- returns NULL (no userinfo)
       PARSE_URL(url2, 'QUERY')          AS var10  -- returns NULL (urlStr is NULL)
FROM T1;