连接hive

$SPARK_HOME/bin/beeline -u “jdbc:hive2://localhost:10000” -n “admin” -p “hik12345+”;

建表

在hive中的awaken_result库中建表,如建表:wm_train_data
使用数据库:use awaken_result;
执行建表语句:
create table wm_train_data(f1 Double,f2 Double,f3 Double,f4 Double,label Integer) ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘,’ ESCAPED BY ‘\’ STORED AS TEXTFILE;
create table feat(id Integer,e Double,c Double,b Double,a Double,d Double,label Integer) ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘,’ ESCAPED BY ‘\’ STORED AS TEXTFILE;
create table cora(id Integer,feat0 Double,feat1 Double,feat2 Double,feat3 Double,feat4 Double,feat5 Double,feat6 Double,feat7 Double,feat8 Double,feat9 Double,feat10 Double,feat11 Double,feat12 Double,feat13 Double,feat14 Double,feat15 Double,feat16 Double,feat17 Double,feat18 Double,feat19 Double,feat20 Double,feat21 Double,feat22 Double,feat23 Double,feat24 Double,feat25 Double,feat26 Double,feat27 Double,feat28 Double,feat29 Double,feat30 Double,feat31 Double,feat32 Double,feat33 Double,feat34 Double,feat35 Double,feat36 Double,feat37 Double,feat38 Double,feat39 Double,feat40 Double,feat41 Double,feat42 Double,feat43 Double,feat44 Double,feat45 Double,feat46 Double,feat47 Double,feat48 Double,feat49 Double,feat50 Double,feat51 Double,feat52 Double,feat53 Double,feat54 Double,feat55 Double,feat56 Double,feat57 Double,feat58 Double,feat59 Double,feat60 Double,feat61 Double,feat62 Double,feat63 Double,feat64 Double,feat65 Double,feat66 Double,feat67 Double,feat68 Double,feat69 Double,feat70 Double,feat71 Double,feat72 Double,feat73 Double,feat74 Double,feat75 Double,feat76 Double,feat77 Double,feat78 Double,feat79 Double,feat80 Double,feat81 Double,feat82 Double,feat83 Double,feat84 Double,feat85 Double,feat86 Double,feat87 Double,feat88 Double,feat89 Double,feat90 Double,feat91 Double,feat92 Double,feat93 Double,feat94 Double,feat95 Double,feat96 Double,feat97 Double,feat98 Double,feat99 Double,feat100 Double,feat101 Double,feat102 Double,feat103 Double,feat104 Double,feat105 Double,feat106 Double,feat107 Double,feat108 Double,feat109 Double,feat110 Double,feat111 Double,feat112 Double,feat113 Double,feat114 Double,feat115 Double,feat116 Double,feat117 Double,feat118 Double,feat119 Double,feat120 Double,feat121 Double,feat122 Double,feat123 Double,feat124 Double,feat125 Double,feat126 Double,feat127 Double,feat128 Double,feat129 Double,feat130 Double,feat131 Double,feat132 Double,feat133 Double,feat134 Double,feat135 Double,feat136 Double,feat137 Double,feat138 Double,feat139 Double,feat140 Double,feat141 Double,feat142 Double,feat143 Double,feat144 Double,feat145 Double,feat146 Double,feat147 Double,feat148 Double,feat149 Double,feat150 Double,feat151 Double,feat152 Double,feat153 Double,feat154 Double,feat155 Double,feat156 Double,feat157 Double,feat158 Double,feat159 Double,feat160 Double,feat161 Double,feat162 Double,feat163 Double,feat164 Double,feat165 Double,feat166 Double,feat167 Double,feat168 Double,feat169 Double,feat170 Double,feat171 Double,feat172 Double,feat173 Double,feat174 Double,feat175 Double,feat176 Double,feat177 Double,feat178 Double,feat179 Double,feat180 Double,feat181 Double,feat182 Double,feat183 Double,feat184 Double,feat185 Double,feat186 Double,feat187 Double,feat188 Double,feat189 Double,feat190 Double,feat191 Double,feat192 Double,feat193 Double,feat194 Double,feat195 Double,feat196 Double,feat197 Double,feat198 Double,feat199 Double,feat200 Double,feat201 Double,feat202 Double,feat203 Double,feat204 Double,feat205 Double,feat206 Double,feat207 Double,feat208 Double,feat209 Double,feat210 Double,feat211 Double,feat212 Double,feat213 Double,feat214 Double,feat215 Double,feat216 Double,feat217 Double,feat218 Double,feat219 Double,feat220 Double,feat221 Double,feat222 Double,feat223 Double,feat224 Double,feat225 Double,feat226 Double,feat227 Double,feat228 Double,feat229 Double,feat230 Double,feat231 Double,feat232 Double,feat233 Double,feat234 Double,feat235 Double,feat236 Double,feat237 Double,feat238 Double,feat239 Double,feat240 Double,feat241 Double,feat242 Double,feat243 Double,feat244 Double,feat245 Double,feat246 Double,feat247 Double,feat248 Double,feat249 Double,feat250 Double,feat251 Double,feat252 Double,feat253 Double,feat254 Double,feat255 Double,feat256 Double,feat257 Double,feat258 Double,feat259 Double,feat260 Double,feat261 Double,feat262 Double,feat263 Double,feat264 Double,feat265 Double,feat266 Double,feat267 Double,feat268 Double,feat269 Double,feat270 Double,feat271 Double,feat272 Double,feat273 Double,feat274 Double,feat275 Double,feat276 Double,feat277 Double,feat278 Double,feat279 Double,feat280 Double,feat281 Double,feat282 Double,feat283 Double,feat284 Double,feat285 Double,feat286 Double,feat287 Double,feat288 Double,feat289 Double,feat290 Double,feat291 Double,feat292 Double,feat293 Double,feat294 Double,feat295 Double,feat296 Double,feat297 Double,feat298 Double,feat299 Double,feat300 Double,feat301 Double,feat302 Double,feat303 Double,feat304 Double,feat305 Double,feat306 Double,feat307 Double,feat308 Double,feat309 Double,feat310 Double,feat311 Double,feat312 Double,feat313 Double,feat314 Double,feat315 Double,feat316 Double,feat317 Double,feat318 Double,feat319 Double,feat320 Double,feat321 Double,feat322 Double,feat323 Double,feat324 Double,feat325 Double,feat326 Double,feat327 Double,feat328 Double,feat329 Double,feat330 Double,feat331 Double,feat332 Double,feat333 Double,feat334 Double,feat335 Double,feat336 Double,feat337 Double,feat338 Double,feat339 Double,feat340 Double,feat341 Double,feat342 Double,feat343 Double,feat344 Double,feat345 Double,feat346 Double,feat347 Double,feat348 Double,feat349 Double,feat350 Double,feat351 Double,feat352 Double,feat353 Double,feat354 Double,feat355 Double,feat356 Double,feat357 Double,feat358 Double,feat359 Double,feat360 Double,feat361 Double,feat362 Double,feat363 Double,feat364 Double,feat365 Double,feat366 Double,feat367 Double,feat368 Double,feat369 Double,feat370 Double,feat371 Double,feat372 Double,feat373 Double,feat374 Double,feat375 Double,feat376 Double,feat377 Double,feat378 Double,feat379 Double,feat380 Double,feat381 Double,feat382 Double,feat383 Double,feat384 Double,feat385 Double,feat386 Double,feat387 Double,feat388 Double,feat389 Double,feat390 Double,feat391 Double,feat392 Double,feat393 Double,feat394 Double,feat395 Double,feat396 Double,feat397 Double,feat398 Double,feat399 Double,feat400 Double,feat401 Double,feat402 Double,feat403 Double,feat404 Double,feat405 Double,feat406 Double,feat407 Double,feat408 Double,feat409 Double,feat410 Double,feat411 Double,feat412 Double,feat413 Double,feat414 Double,feat415 Double,feat416 Double,feat417 Double,feat418 Double,feat419 Double,feat420 Double,feat421 Double,feat422 Double,feat423 Double,feat424 Double,feat425 Double,feat426 Double,feat427 Double,feat428 Double,feat429 Double,feat430 Double,feat431 Double,feat432 Double,feat433 Double,feat434 Double,feat435 Double,feat436 Double,feat437 Double,feat438 Double,feat439 Double,feat440 Double,feat441 Double,feat442 Double,feat443 Double,feat444 Double,feat445 Double,feat446 Double,feat447 Double,feat448 Double,feat449 Double,feat450 Double,feat451 Double,feat452 Double,feat453 Double,feat454 Double,feat455 Double,feat456 Double,feat457 Double,feat458 Double,feat459 Double,feat460 Double,feat461 Double,feat462 Double,feat463 Double,feat464 Double,feat465 Double,feat466 Double,feat467 Double,feat468 Double,feat469 Double,feat470 Double,feat471 Double,feat472 Double,feat473 Double,feat474 Double,feat475 Double,feat476 Double,feat477 Double,feat478 Double,feat479 Double,feat480 Double,feat481 Double,feat482 Double,feat483 Double,feat484 Double,feat485 Double,feat486 Double,feat487 Double,feat488 Double,feat489 Double,feat490 Double,feat491 Double,feat492 Double,feat493 Double,feat494 Double,feat495 Double,feat496 Double,feat497 Double,feat498 Double,feat499 Double,feat500 Double,feat501 Double,feat502 Double,feat503 Double,feat504 Double,feat505 Double,feat506 Double,feat507 Double,feat508 Double,feat509 Double,feat510 Double,feat511 Double,feat512 Double,feat513 Double,feat514 Double,feat515 Double,feat516 Double,feat517 Double,feat518 Double,feat519 Double,feat520 Double,feat521 Double,feat522 Double,feat523 Double,feat524 Double,feat525 Double,feat526 Double,feat527 Double,feat528 Double,feat529 Double,feat530 Double,feat531 Double,feat532 Double,feat533 Double,feat534 Double,feat535 Double,feat536 Double,feat537 Double,feat538 Double,feat539 Double,feat540 Double,feat541 Double,feat542 Double,feat543 Double,feat544 Double,feat545 Double,feat546 Double,feat547 Double,feat548 Double,feat549 Double,feat550 Double,feat551 Double,feat552 Double,feat553 Double,feat554 Double,feat555 Double,feat556 Double,feat557 Double,feat558 Double,feat559 Double,feat560 Double,feat561 Double,feat562 Double,feat563 Double,feat564 Double,feat565 Double,feat566 Double,feat567 Double,feat568 Double,feat569 Double,feat570 Double,feat571 Double,feat572 Double,feat573 Double,feat574 Double,feat575 Double,feat576 Double,feat577 Double,feat578 Double,feat579 Double,feat580 Double,feat581 Double,feat582 Double,feat583 Double,feat584 Double,feat585 Double,feat586 Double,feat587 Double,feat588 Double,feat589 Double,feat590 Double,feat591 Double,feat592 Double,feat593 Double,feat594 Double,feat595 Double,feat596 Double,feat597 Double,feat598 Double,feat599 Double,feat600 Double,feat601 Double,feat602 Double,feat603 Double,feat604 Double,feat605 Double,feat606 Double,feat607 Double,feat608 Double,feat609 Double,feat610 Double,feat611 Double,feat612 Double,feat613 Double,feat614 Double,feat615 Double,feat616 Double,feat617 Double,feat618 Double,feat619 Double,feat620 Double,feat621 Double,feat622 Double,feat623 Double,feat624 Double,feat625 Double,feat626 Double,feat627 Double,feat628 Double,feat629 Double,feat630 Double,feat631 Double,feat632 Double,feat633 Double,feat634 Double,feat635 Double,feat636 Double,feat637 Double,feat638 Double,feat639 Double,feat640 Double,feat641 Double,feat642 Double,feat643 Double,feat644 Double,feat645 Double,feat646 Double,feat647 Double,feat648 Double,feat649 Double,feat650 Double,feat651 Double,feat652 Double,feat653 Double,feat654 Double,feat655 Double,feat656 Double,feat657 Double,feat658 Double,feat659 Double,feat660 Double,feat661 Double,feat662 Double,feat663 Double,feat664 Double,feat665 Double,feat666 Double,feat667 Double,feat668 Double,feat669 Double,feat670 Double,feat671 Double,feat672 Double,feat673 Double,feat674 Double,feat675 Double,feat676 Double,feat677 Double,feat678 Double,feat679 Double,feat680 Double,feat681 Double,feat682 Double,feat683 Double,feat684 Double,feat685 Double,feat686 Double,feat687 Double,feat688 Double,feat689 Double,feat690 Double,feat691 Double,feat692 Double,feat693 Double,feat694 Double,feat695 Double,feat696 Double,feat697 Double,feat698 Double,feat699 Double,feat700 Double,feat701 Double,feat702 Double,feat703 Double,feat704 Double,feat705 Double,feat706 Double,feat707 Double,feat708 Double,feat709 Double,feat710 Double,feat711 Double,feat712 Double,feat713 Double,feat714 Double,feat715 Double,feat716 Double,feat717 Double,feat718 Double,feat719 Double,feat720 Double,feat721 Double,feat722 Double,feat723 Double,feat724 Double,feat725 Double,feat726 Double,feat727 Double,feat728 Double,feat729 Double,feat730 Double,feat731 Double,feat732 Double,feat733 Double,feat734 Double,feat735 Double,feat736 Double,feat737 Double,feat738 Double,feat739 Double,feat740 Double,feat741 Double,feat742 Double,feat743 Double,feat744 Double,feat745 Double,feat746 Double,feat747 Double,feat748 Double,feat749 Double,feat750 Double,feat751 Double,feat752 Double,feat753 Double,feat754 Double,feat755 Double,feat756 Double,feat757 Double,feat758 Double,feat759 Double,feat760 Double,feat761 Double,feat762 Double,feat763 Double,feat764 Double,feat765 Double,feat766 Double,feat767 Double,feat768 Double,feat769 Double,feat770 Double,feat771 Double,feat772 Double,feat773 Double,feat774 Double,feat775 Double,feat776 Double,feat777 Double,feat778 Double,feat779 Double,feat780 Double,feat781 Double,feat782 Double,feat783 Double,feat784 Double,feat785 Double,feat786 Double,feat787 Double,feat788 Double,feat789 Double,feat790 Double,feat791 Double,feat792 Double,feat793 Double,feat794 Double,feat795 Double,feat796 Double,feat797 Double,feat798 Double,feat799 Double,feat800 Double,feat801 Double,feat802 Double,feat803 Double,feat804 Double,feat805 Double,feat806 Double,feat807 Double,feat808 Double,feat809 Double,feat810 Double,feat811 Double,feat812 Double,feat813 Double,feat814 Double,feat815 Double,feat816 Double,feat817 Double,feat818 Double,feat819 Double,feat820 Double,feat821 Double,feat822 Double,feat823 Double,feat824 Double,feat825 Double,feat826 Double,feat827 Double,feat828 Double,feat829 Double,feat830 Double,feat831 Double,feat832 Double,feat833 Double,feat834 Double,feat835 Double,feat836 Double,feat837 Double,feat838 Double,feat839 Double,feat840 Double,feat841 Double,feat842 Double,feat843 Double,feat844 Double,feat845 Double,feat846 Double,feat847 Double,feat848 Double,feat849 Double,feat850 Double,feat851 Double,feat852 Double,feat853 Double,feat854 Double,feat855 Double,feat856 Double,feat857 Double,feat858 Double,feat859 Double,feat860 Double,feat861 Double,feat862 Double,feat863 Double,feat864 Double,feat865 Double,feat866 Double,feat867 Double,feat868 Double,feat869 Double,feat870 Double,feat871 Double,feat872 Double,feat873 Double,feat874 Double,feat875 Double,feat876 Double,feat877 Double,feat878 Double,feat879 Double,feat880 Double,feat881 Double,feat882 Double,feat883 Double,feat884 Double,feat885 Double,feat886 Double,feat887 Double,feat888 Double,feat889 Double,feat890 Double,feat891 Double,feat892 Double,feat893 Double,feat894 Double,feat895 Double,feat896 Double,feat897 Double,feat898 Double,feat899 Double,feat900 Double,feat901 Double,feat902 Double,feat903 Double,feat904 Double,feat905 Double,feat906 Double,feat907 Double,feat908 Double,feat909 Double,feat910 Double,feat911 Double,feat912 Double,feat913 Double,feat914 Double,feat915 Double,feat916 Double,feat917 Double,feat918 Double,feat919 Double,feat920 Double,feat921 Double,feat922 Double,feat923 Double,feat924 Double,feat925 Double,feat926 Double,feat927 Double,feat928 Double,feat929 Double,feat930 Double,feat931 Double,feat932 Double,feat933 Double,feat934 Double,feat935 Double,feat936 Double,feat937 Double,feat938 Double,feat939 Double,feat940 Double,feat941 Double,feat942 Double,feat943 Double,feat944 Double,feat945 Double,feat946 Double,feat947 Double,feat948 Double,feat949 Double,feat950 Double,feat951 Double,feat952 Double,feat953 Double,feat954 Double,feat955 Double,feat956 Double,feat957 Double,feat958 Double,feat959 Double,feat960 Double,feat961 Double,feat962 Double,feat963 Double,feat964 Double,feat965 Double,feat966 Double,feat967 Double,feat968 Double,feat969 Double,feat970 Double,feat971 Double,feat972 Double,feat973 Double,feat974 Double,feat975 Double,feat976 Double,feat977 Double,feat978 Double,feat979 Double,feat980 Double,feat981 Double,feat982 Double,feat983 Double,feat984 Double,feat985 Double,feat986 Double,feat987 Double,feat988 Double,feat989 Double,feat990 Double,feat991 Double,feat992 Double,feat993 Double,feat994 Double,feat995 Double,feat996 Double,feat997 Double,feat998 Double,feat999 Double,feat1000 Double,feat1001 Double,feat1002 Double,feat1003 Double,feat1004 Double,feat1005 Double,feat1006 Double,feat1007 Double,feat1008 Double,feat1009 Double,feat1010 Double,feat1011 Double,feat1012 Double,feat1013 Double,feat1014 Double,feat1015 Double,feat1016 Double,feat1017 Double,feat1018 Double,feat1019 Double,feat1020 Double,feat1021 Double,feat1022 Double,feat1023 Double,feat1024 Double,feat1025 Double,feat1026 Double,feat1027 Double,feat1028 Double,feat1029 Double,feat1030 Double,feat1031 Double,feat1032 Double,feat1033 Double,feat1034 Double,feat1035 Double,feat1036 Double,feat1037 Double,feat1038 Double,feat1039 Double,feat1040 Double,feat1041 Double,feat1042 Double,feat1043 Double,feat1044 Double,feat1045 Double,feat1046 Double,feat1047 Double,feat1048 Double,feat1049 Double,feat1050 Double,feat1051 Double,feat1052 Double,feat1053 Double,feat1054 Double,feat1055 Double,feat1056 Double,feat1057 Double,feat1058 Double,feat1059 Double,feat1060 Double,feat1061 Double,feat1062 Double,feat1063 Double,feat1064 Double,feat1065 Double,feat1066 Double,feat1067 Double,feat1068 Double,feat1069 Double,feat1070 Double,feat1071 Double,feat1072 Double,feat1073 Double,feat1074 Double,feat1075 Double,feat1076 Double,feat1077 Double,feat1078 Double,feat1079 Double,feat1080 Double,feat1081 Double,feat1082 Double,feat1083 Double,feat1084 Double,feat1085 Double,feat1086 Double,feat1087 Double,feat1088 Double,feat1089 Double,feat1090 Double,feat1091 Double,feat1092 Double,feat1093 Double,feat1094 Double,feat1095 Double,feat1096 Double,feat1097 Double,feat1098 Double,feat1099 Double,feat1100 Double,feat1101 Double,feat1102 Double,feat1103 Double,feat1104 Double,feat1105 Double,feat1106 Double,feat1107 Double,feat1108 Double,feat1109 Double,feat1110 Double,feat1111 Double,feat1112 Double,feat1113 Double,feat1114 Double,feat1115 Double,feat1116 Double,feat1117 Double,feat1118 Double,feat1119 Double,feat1120 Double,feat1121 Double,feat1122 Double,feat1123 Double,feat1124 Double,feat1125 Double,feat1126 Double,feat1127 Double,feat1128 Double,feat1129 Double,feat1130 Double,feat1131 Double,feat1132 Double,feat1133 Double,feat1134 Double,feat1135 Double,feat1136 Double,feat1137 Double,feat1138 Double,feat1139 Double,feat1140 Double,feat1141 Double,feat1142 Double,feat1143 Double,feat1144 Double,feat1145 Double,feat1146 Double,feat1147 Double,feat1148 Double,feat1149 Double,feat1150 Double,feat1151 Double,feat1152 Double,feat1153 Double,feat1154 Double,feat1155 Double,feat1156 Double,feat1157 Double,feat1158 Double,feat1159 Double,feat1160 Double,feat1161 Double,feat1162 Double,feat1163 Double,feat1164 Double,feat1165 Double,feat1166 Double,feat1167 Double,feat1168 Double,feat1169 Double,feat1170 Double,feat1171 Double,feat1172 Double,feat1173 Double,feat1174 Double,feat1175 Double,feat1176 Double,feat1177 Double,feat1178 Double,feat1179 Double,feat1180 Double,feat1181 Double,feat1182 Double,feat1183 Double,feat1184 Double,feat1185 Double,feat1186 Double,feat1187 Double,feat1188 Double,feat1189 Double,feat1190 Double,feat1191 Double,feat1192 Double,feat1193 Double,feat1194 Double,feat1195 Double,feat1196 Double,feat1197 Double,feat1198 Double,feat1199 Double,feat1200 Double,feat1201 Double,feat1202 Double,feat1203 Double,feat1204 Double,feat1205 Double,feat1206 Double,feat1207 Double,feat1208 Double,feat1209 Double,feat1210 Double,feat1211 Double,feat1212 Double,feat1213 Double,feat1214 Double,feat1215 Double,feat1216 Double,feat1217 Double,feat1218 Double,feat1219 Double,feat1220 Double,feat1221 Double,feat1222 Double,feat1223 Double,feat1224 Double,feat1225 Double,feat1226 Double,feat1227 Double,feat1228 Double,feat1229 Double,feat1230 Double,feat1231 Double,feat1232 Double,feat1233 Double,feat1234 Double,feat1235 Double,feat1236 Double,feat1237 Double,feat1238 Double,feat1239 Double,feat1240 Double,feat1241 Double,feat1242 Double,feat1243 Double,feat1244 Double,feat1245 Double,feat1246 Double,feat1247 Double,feat1248 Double,feat1249 Double,feat1250 Double,feat1251 Double,feat1252 Double,feat1253 Double,feat1254 Double,feat1255 Double,feat1256 Double,feat1257 Double,feat1258 Double,feat1259 Double,feat1260 Double,feat1261 Double,feat1262 Double,feat1263 Double,feat1264 Double,feat1265 Double,feat1266 Double,feat1267 Double,feat1268 Double,feat1269 Double,feat1270 Double,feat1271 Double,feat1272 Double,feat1273 Double,feat1274 Double,feat1275 Double,feat1276 Double,feat1277 Double,feat1278 Double,feat1279 Double,feat1280 Double,feat1281 Double,feat1282 Double,feat1283 Double,feat1284 Double,feat1285 Double,feat1286 Double,feat1287 Double,feat1288 Double,feat1289 Double,feat1290 Double,feat1291 Double,feat1292 Double,feat1293 Double,feat1294 Double,feat1295 Double,feat1296 Double,feat1297 Double,feat1298 Double,feat1299 Double,feat1300 Double,feat1301 Double,feat1302 Double,feat1303 Double,feat1304 Double,feat1305 Double,feat1306 Double,feat1307 Double,feat1308 Double,feat1309 Double,feat1310 Double,feat1311 Double,feat1312 Double,feat1313 Double,feat1314 Double,feat1315 Double,feat1316 Double,feat1317 Double,feat1318 Double,feat1319 Double,feat1320 Double,feat1321 Double,feat1322 Double,feat1323 Double,feat1324 Double,feat1325 Double,feat1326 Double,feat1327 Double,feat1328 Double,feat1329 Double,feat1330 Double,feat1331 Double,feat1332 Double,feat1333 Double,feat1334 Double,feat1335 Double,feat1336 Double,feat1337 Double,feat1338 Double,feat1339 Double,feat1340 Double,feat1341 Double,feat1342 Double,feat1343 Double,feat1344 Double,feat1345 Double,feat1346 Double,feat1347 Double,feat1348 Double,feat1349 Double,feat1350 Double,feat1351 Double,feat1352 Double,feat1353 Double,feat1354 Double,feat1355 Double,feat1356 Double,feat1357 Double,feat1358 Double,feat1359 Double,feat1360 Double,feat1361 Double,feat1362 Double,feat1363 Double,feat1364 Double,feat1365 Double,feat1366 Double,feat1367 Double,feat1368 Double,feat1369 Double,feat1370 Double,feat1371 Double,feat1372 Double,feat1373 Double,feat1374 Double,feat1375 Double,feat1376 Double,feat1377 Double,feat1378 Double,feat1379 Double,feat1380 Double,feat1381 Double,feat1382 Double,feat1383 Double,feat1384 Double,feat1385 Double,feat1386 Double,feat1387 Double,feat1388 Double,feat1389 Double,feat1390 Double,feat1391 Double,feat1392 Double,feat1393 Double,feat1394 Double,feat1395 Double,feat1396 Double,feat1397 Double,feat1398 Double,feat1399 Double,feat1400 Double,feat1401 Double,feat1402 Double,feat1403 Double,feat1404 Double,feat1405 Double,feat1406 Double,feat1407 Double,feat1408 Double,feat1409 Double,feat1410 Double,feat1411 Double,feat1412 Double,feat1413 Double,feat1414 Double,feat1415 Double,feat1416 Double,feat1417 Double,feat1418 Double,feat1419 Double,feat1420 Double,feat1421 Double,feat1422 Double,feat1423 Double,feat1424 Double,feat1425 Double,feat1426 Double,feat1427 Double,feat1428 Double,feat1429 Double,feat1430 Double,feat1431 Double,feat1432 Double,label Integer) ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘,’ ESCAPED BY ‘\’ STORED AS TEXTFILE;

导入数据

准备导入的数据,例如这里数据位置为:/home/wumei/data.txt,执行导入命令,注意数据要与建表语句的schema对应
LOAD DATA LOCAL INPATH ‘/home/wumei/data.txt’ OVERWRITE INTO TABLE wm_train_data;
LOAD DATA LOCAL INPATH ‘/mnt/disk1/users/liuchenguang/node_feat.csv’ OVERWRITE INTO TABLE feat;
LOAD DATA LOCAL INPATH ‘/mnt/disk1/users/liuchenguang/cora_nodes-no-header.csv’ OVERWRITE INTO TABLE cora;