PageRenderTime 48ms CodeModel.GetById 23ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/udf_unhex.q.out

#
text | 71 lines | 67 code | 4 blank | 0 comment | 0 complexity | a23832d9899011678a111a8bfd9a32af MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: DESCRIBE FUNCTION unhex
    2. 

  2. PREHOOK: type: DESCFUNCTION
    3. 

  3. POSTHOOK: query: DESCRIBE FUNCTION unhex
    4. 

  4. POSTHOOK: type: DESCFUNCTION
    5. 

  5. unhex(str) - Converts hexadecimal argument to string
    6. 

  6. PREHOOK: query: DESCRIBE FUNCTION EXTENDED unhex
    7. 

  7. PREHOOK: type: DESCFUNCTION
    8. 

  8. POSTHOOK: query: DESCRIBE FUNCTION EXTENDED unhex
    9. 

  9. POSTHOOK: type: DESCFUNCTION
    10. 

  10. unhex(str) - Converts hexadecimal argument to string
    11. 

  11. Performs the inverse operation of HEX(str). That is, it interprets
    12. 

  12. each pair of hexadecimal digits in the argument as a number and
    13. 

  13. converts it to the character represented by the number. The
    14. 

  14. resulting characters are returned as a binary string.
    15. 

  15. 

  16. Example:
    17. 

  17. > SELECT UNHEX('4D7953514C') from src limit 1;
    18. 

  18. 'MySQL'
    19. 

  19. > SELECT UNHEX(HEX('string')) from src limit 1;
    20. 

  20. 'string'
    21. 

  21. > SELECT HEX(UNHEX('1267')) from src limit 1;
    22. 

  22. '1267'
    23. 

  23. 

  24. The characters in the argument string must be legal hexadecimal
    25. 

  25. digits: '0' .. '9', 'A' .. 'F', 'a' .. 'f'. If UNHEX() encounters
    26. 

  26. any nonhexadecimal digits in the argument, it returns NULL. Also,
    27. 

  27. if there are an odd number of characters a leading 0 is appended.
    28. 

  28. PREHOOK: query: -- Good inputs
    29. 

  29. 

  30. SELECT
    31. 

  31.   unhex('4D7953514C'),
    32. 

  32.   unhex('31323637'),
    33. 

  33.   unhex('61'),
    34. 

  34.   unhex('2D34'),
    35. 

  35.   unhex('')
    36. 

  36. FROM src limit 1
    37. 

  37. PREHOOK: type: QUERY
    38. 

  38. PREHOOK: Input: default@src
    39. 

  39. PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1211131149/10000
    40. 

  40. POSTHOOK: query: -- Good inputs
    41. 

  41. 

  42. SELECT
    43. 

  43.   unhex('4D7953514C'),
    44. 

  44.   unhex('31323637'),
    45. 

  45.   unhex('61'),
    46. 

  46.   unhex('2D34'),
    47. 

  47.   unhex('')
    48. 

  48. FROM src limit 1
    49. 

  49. POSTHOOK: type: QUERY
    50. 

  50. POSTHOOK: Input: default@src
    51. 

  51. POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1211131149/10000
    52. 

  52. MySQL	1267	a	-4	
    53. 

  53. PREHOOK: query: -- Bad inputs
    54. 

  54. SELECT
    55. 

  55.   unhex('MySQL'),
    56. 

  56.   unhex('G123'),
    57. 

  57.   unhex('\0')
    58. 

  58. FROM src limit 1
    59. 

  59. PREHOOK: type: QUERY
    60. 

  60. PREHOOK: Input: default@src
    61. 

  61. PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1374300168/10000
    62. 

  62. POSTHOOK: query: -- Bad inputs
    63. 

  63. SELECT
    64. 

  64.   unhex('MySQL'),
    65. 

  65.   unhex('G123'),
    66. 

  66.   unhex('\0')
    67. 

  67. FROM src limit 1
    68. 

  68. POSTHOOK: type: QUERY
    69. 

  69. POSTHOOK: Input: default@src
    70. 

  70. POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1374300168/10000
    71. 

  71. NULL	NULL	NULL
    72. 

  72.