https://blog.youkuaiyun.com/Octemullzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/Octemull/article/details/76263730https://blog.youkuaiyun.com/Octemull/article/details/76263730OctemullFri, 28 Jul 2017 15:43:24 +0800https://blog.youkuaiyun.com/Octemull/article/details/76215980https://blog.youkuaiyun.com/Octemull/article/details/76215980OctemullThu, 27 Jul 2017 18:26:27 +0800 Create table lxw_test as select map('100','tom','200','mary')as t from lxw_dual; ]]>https://blog.youkuaiyun.com/Octemull/article/details/76215959https://blog.youkuaiyun.com/Octemull/article/details/76215959OctemullThu, 27 Jul 2017 18:24:30 +0800 select length('abcedfg') from lxw_dual; 7 2. 字符串反转函数：reverse 语法: reverse(string A) 返回值: string]]>https://blog.youkuaiyun.com/Octemull/article/details/76215940https://blog.youkuaiyun.com/Octemull/article/details/76215940OctemullThu, 27 Jul 2017 18:22:51 +0800 select round(3.1415926) from lxw_dual; 3 hive> select round(3.5) from lxw_dual; 4]]>https://blog.youkuaiyun.com/Octemull/article/details/76215902https://blog.youkuaiyun.com/Octemull/article/details/76215902OctemullThu, 27 Jul 2017 18:18:00 +0800select 1 from lxw_dual where 1=1;          1 2. 不等值比较:]]>https://blog.youkuaiyun.com/Octemull/article/details/76215368https://blog.youkuaiyun.com/Octemull/article/details/76215368OctemullThu, 27 Jul 2017 18:11:01 +0800