PageRenderTime 45ms CodeModel.GetById 19ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/udf_bin.q.out

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

  1. PREHOOK: query: DESCRIBE FUNCTION bin
    2. 

  2. PREHOOK: type: DESCFUNCTION
    3. 

  3. POSTHOOK: query: DESCRIBE FUNCTION bin
    4. 

  4. POSTHOOK: type: DESCFUNCTION
    5. 

  5. bin(n) - returns n in binary
    6. 

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

  7. PREHOOK: type: DESCFUNCTION
    8. 

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

  9. POSTHOOK: type: DESCFUNCTION
    10. 

  10. bin(n) - returns n in binary
    11. 

  11. n is a BIGINT. Returns NULL if n is NULL.
    12. 

  12. Example:
    13. 

  13.   > SELECT bin(13) FROM src LIMIT 1
    14. 

  14.   '1101'
    15. 

  15. PREHOOK: query: SELECT
    16. 

  16.   bin(1),
    17. 

  17.   bin(0),
    18. 

  18.   bin(99992421)
    19. 

  19. FROM src LIMIT 1
    20. 

  20. PREHOOK: type: QUERY
    21. 

  21. PREHOOK: Input: default@src
    22. 

  22. PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/888920394/10000
    23. 

  23. POSTHOOK: query: SELECT
    24. 

  24.   bin(1),
    25. 

  25.   bin(0),
    26. 

  26.   bin(99992421)
    27. 

  27. FROM src LIMIT 1
    28. 

  28. POSTHOOK: type: QUERY
    29. 

  29. POSTHOOK: Input: default@src
    30. 

  30. POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/888920394/10000
    31. 

  31. 1	0	101111101011100001101100101
    32. 

  32. PREHOOK: query: -- Negative numbers should be treated as two's complement (64 bit).
    33. 

  33. SELECT bin(-5) FROM src LIMIT 1
    34. 

  34. PREHOOK: type: QUERY
    35. 

  35. PREHOOK: Input: default@src
    36. 

  36. PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1468739151/10000
    37. 

  37. POSTHOOK: query: -- Negative numbers should be treated as two's complement (64 bit).
    38. 

  38. SELECT bin(-5) FROM src LIMIT 1
    39. 

  39. POSTHOOK: type: QUERY
    40. 

  40. POSTHOOK: Input: default@src
    41. 

  41. POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1468739151/10000
    42. 

  42. 1111111111111111111111111111111111111111111111111111111111111011
    43. 

  43.