0: jdbc:hive2://hadoop102:10000> select substring('asdfghjk;',1,3);
+------+
| _c0 |
+------+
| asd |
+------+
1 row selected (0.192 seconds)

0: jdbc:hive2://hadoop102:10000> select substring('asdfghjk;',1,3);
+------+
| _c0 |
+------+
| asd |
+------+
1 row selected (0.192 seconds)