0001
0002
0003
0004
0005
0006
0007
0008
0009
0010
0011
0012
0013
0014
0015
0016
0017
0018 CREATE TEMPORARY VIEW t AS SELECT 'aa' as a;
0019
0020
0021 select cast(a as byte) from t;
0022 select cast(a as short) from t;
0023 select cast(a as int) from t;
0024 select cast(a as long) from t;
0025 select cast(a as float) from t;
0026 select cast(a as double) from t;
0027 select cast(a as decimal) from t;
0028 select cast(a as boolean) from t;
0029 select cast(a as timestamp) from t;
0030 select cast(a as date) from t;
0031
0032 select cast(a as binary) from t;
0033
0034 select cast(a as array<string>) from t;
0035 select cast(a as struct<s:string>) from t;
0036 select cast(a as map<string, string>) from t;
0037
0038
0039 select to_timestamp(a) from t;
0040 select to_timestamp('2018-01-01', a) from t;
0041 select to_unix_timestamp(a) from t;
0042 select to_unix_timestamp('2018-01-01', a) from t;
0043 select unix_timestamp(a) from t;
0044 select unix_timestamp('2018-01-01', a) from t;
0045 select from_unixtime(a) from t;
0046 select from_unixtime('2018-01-01', a) from t;
0047 select next_day(a, 'MO') from t;
0048 select next_day('2018-01-01', a) from t;
0049 select trunc(a, 'MM') from t;
0050 select trunc('2018-01-01', a) from t;
0051
0052
0053 select unhex('-123');
0054 select sha2(a, a) from t;
0055 select get_json_object(a, a) from t;
0056 select json_tuple(a, a) from t;
0057 select from_json(a, 'a INT') from t;