/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/udf_xpath_float.q

# · text · 11 lines · 10 code · 1 blank · 0 comment · 0 complexity · 6e40276d0a9eaa4a31fc1aa117a7f3d3 MD5 · raw file 

    

  1. DESCRIBE FUNCTION xpath_float ;
    2. 

  2. DESCRIBE FUNCTION EXTENDED xpath_float ;
    3. 

  3. 

  4. SELECT xpath_float ('<a>this is not a number</a>', 'a') FROM src LIMIT 1 ;
    5. 

  5. SELECT xpath_float ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1 ;
    6. 

  6. SELECT xpath_float ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1 ;
    7. 

  7. SELECT xpath_float ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1 ;
    8. 

  8. SELECT xpath_float ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'a/b') FROM src LIMIT 1 ;
    9. 

  9. SELECT xpath_float ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/*)') FROM src LIMIT 1 ;
    10. 

  10. SELECT xpath_float ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b)') FROM src LIMIT 1 ;
    11. 

  11. SELECT xpath_float ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b[@class="odd"])') FROM src LIMIT 1 ;
    12.