PageRenderTime 18ms CodeModel.GetById 15ms app.highlight 1ms RepoModel.GetById 1ms 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
 1PREHOOK: query: DESCRIBE FUNCTION bin
 2PREHOOK: type: DESCFUNCTION
 3POSTHOOK: query: DESCRIBE FUNCTION bin
 4POSTHOOK: type: DESCFUNCTION
 5bin(n) - returns n in binary
 6PREHOOK: query: DESCRIBE FUNCTION EXTENDED bin
 7PREHOOK: type: DESCFUNCTION
 8POSTHOOK: query: DESCRIBE FUNCTION EXTENDED bin
 9POSTHOOK: type: DESCFUNCTION
10bin(n) - returns n in binary
11n is a BIGINT. Returns NULL if n is NULL.
12Example:
13  > SELECT bin(13) FROM src LIMIT 1
14  '1101'
15PREHOOK: query: SELECT
16  bin(1),
17  bin(0),
18  bin(99992421)
19FROM src LIMIT 1
20PREHOOK: type: QUERY
21PREHOOK: Input: default@src
22PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/888920394/10000
23POSTHOOK: query: SELECT
24  bin(1),
25  bin(0),
26  bin(99992421)
27FROM src LIMIT 1
28POSTHOOK: type: QUERY
29POSTHOOK: Input: default@src
30POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/888920394/10000
311	0	101111101011100001101100101
32PREHOOK: query: -- Negative numbers should be treated as two's complement (64 bit).
33SELECT bin(-5) FROM src LIMIT 1
34PREHOOK: type: QUERY
35PREHOOK: Input: default@src
36PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1468739151/10000
37POSTHOOK: query: -- Negative numbers should be treated as two's complement (64 bit).
38SELECT bin(-5) FROM src LIMIT 1
39POSTHOOK: type: QUERY
40POSTHOOK: Input: default@src
41POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1468739151/10000
421111111111111111111111111111111111111111111111111111111111111011