impala refresh 分区表

最新推荐文章于 2023-04-12 15:06:33 发布
最新推荐文章于 2023-04-12 15:06:33 发布
阅读量2k 收藏 1
点赞数
分类专栏： hadoop
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/shushugood/article/details/79277973
版权

大家都知道compute stats 指令是impala神兵，这里就不累述。

莫非就是

compute stats xxx表

show table stats xx表

show column stats xx表


分区表，如果你执行compute stats, 那你可以去财务领取200元， 这个和invalidate metadata 后面不带表名一样的效果。

整个集群会hang住，io，cpu都会上来。

所以你需要每个分区单独执行。

比如：

[slave01:21000] > show column stats st_ct_app_hour;
Query: show column stats st_ct_app_hour
+-------------------------------+-----------+------------------+--------+----------+----------+
| Column                        | Type      | #Distinct Values | #Nulls | Max Size | Avg Size |
+-------------------------------+-----------+------------------+--------+----------+----------+
| timevalue                     | TIMESTAMP | -1               | -1     | 16       | 16       |
| rat                           | STRING    | -1               | -1     | -1       | -1       |
| city                          | STRING    | -1               | -1     | -1       | -1       |
| app_type_l1                   | STRING    | -1               | -1     | -1       | -1       |
| app_type_l2                   | STRING    | -1               | -1     | -1       | -1       |
| app_sub_type                  | STRING    | -1               | -1     | -1       | -1       |
| kpi_nbrdnsresreq              | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_nbrdnsressucc             | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_dnsresdelay               | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrtcpconn1streq          | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_nbrtcpconn1stsucc         | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_nbrtcpconn2ndsucc         | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_tcpconn1stdelay           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_tcpconn2nddelay           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_tcpconndelay              | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_tcpulpacketcnt            | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_tcpdlpacketcnt            | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_tcpulretranscnt           | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_tcpdlretranscnt           | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_nbrtcpulrtt               | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_tcpulrttdelay             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrtcpdlrtt               | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_tcpdlrttdelay             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_ultranoctets              | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_dltranoctets              | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrwebreq                 | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_nbrwebressucc             | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_webresdelay               | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrwebopensucc            | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_webopendelay              | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_webdlvalidoctets          | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_webdlvaliddelay           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_web_over50kbcnt           | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_web_over5mbcnt            | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_web_less100kbpscnt        | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_web_100_200kbpscnt        | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_web_200_500kbpscnt        | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_web_500_1mbpscnt          | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_web_over1mbpscnt          | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_web_over2mbpscnt          | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_web_over3mbpscnt          | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_web_over4mbpscnt          | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_web_over5mbpscnt          | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_web_over0mscnt            | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_web_less500mscnt          | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_web_500_1scnt             | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_web_1_2scnt               | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_web_2_3scnt               | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_web_over3scnt             | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_nbrvideoreq               | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_nbrvideoressucc           | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_initbufferduration        | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_initbuffercnt             | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_videobufferduration       | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_videobuffercnt            | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_videobufferservcnt        | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_videodloctets             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_videodlduration           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_dnsressuccratio           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgdnsresdelay            | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_tcpconn1stratio           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgtcpconn1stdelay        | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_tcpconn2ndratio           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgtcpconn2nddelay        | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_tcpconnsuccratio          | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgtcpconndelay           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_tcpulretransratio         | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_tcpdlretransratio         | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgtcpulrttdelay          | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgtcpdlrttdelay          | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_tranoctets                | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_webresratio               | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgwebresdelay            | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrwebopenratio           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgwebopendelay           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgwebdlrate              | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_web_e2e_excellentrate     | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_web_e2e_goodrate          | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_web_e2e_poorrate          | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_web_e2e_promptnessrate    | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_web_e2e_hysteresisrate    | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_videoressuccratio         | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avginitbufferduration     | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgvideobufferduration    | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgvideobuffercnt         | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_videobufferrate           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgperminutebuffercnt     | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgvideodlrate            | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgpergbbuffercnt         | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_web_over500kbpscnt        | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_web_less200kbpscnt        | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_web_less1mbpscnt          | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_videoappdatas             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_videouldatas              | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_videodldatas              | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_dns_over2scnt             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_tcp1st_over2scnt          | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_tcp2nd_over2scnt          | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres1xx             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres2xx             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres3xx             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres4xx             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres5xx             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres200             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres206             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres404             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres505             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrsmallwebopensucc       | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_dns_over2srate            | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_tcp1st_over2srate         | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_tcp2nd_over2srate         | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrimreq                  | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrimsucc                 | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_imsuccratio               | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrimloginreq             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrimloginsucc            | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_imloginsuccratio          | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_imlogindelay              | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgimlogindelay           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrimtextreq              | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrimtextsucc             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_imtextsuccratio           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_imtextdelay               | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgimtextdelay            | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrimpictreq              | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrimpictsucc             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_impictsuccratio           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_impictdelay               | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgimpictdelay            | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrwebpostreq             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrwebpostsucc            | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_webpostsuccratio          | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_webpostdelay              | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgwebpostdelay           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrwebpostcompt           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_webpostcomptratio         | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_webpostcompt50delay       | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrwebpostcompt50         | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgwebpostcompt50delay    | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_webpostupdatas50          | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_webpostupdatas50delay     | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_webpostupdatas50ratio     | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_dnsformaterror            | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_dnsserverfailure          | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_dnsnameerror              | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_dnsnotimplemented         | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_dnsrefused                | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_dnsnotres                 | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres100             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres101             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres201             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres202             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres203             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres204             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres205             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres300             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres301             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres302             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres303             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres304             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres305             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres307             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres400             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres401             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres402             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres403             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres405             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres406             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres407             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres408             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres409             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres410             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres411             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres412             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres413             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres414             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres415             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres416             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres417             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres500             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres501             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres502             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres503             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpres504             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpresext             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrhttpnores              | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_tcpullostpacketcnt        | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_tcpdllostpacketcnt        | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_tcpullostpacketratio      | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_tcpdllostpacketratio      | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrservicepv              | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_initbufferreq             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_initbuffersucc            | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_initbuffersuccratio       | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrwebopenreq             | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_videoserv0bufferrate      | DOUBLE    | -1               | -1     | 8        | 8        |
| appunicode                    | STRING    | -1               | -1     | -1       | -1       |
| app_type                      | STRING    | -1               | -1     | -1       | -1       |
| kpi_recorderreq               | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_recorderressucc           | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_recorderresratio          | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_recorderresdelay          | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avgrecorderresdelay       | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_uporderreq                | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_uporderressucc            | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_uporderresratio           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_uporderresdelay           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_avguporderresdelay        | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrtcplost                | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_tcplostratio              | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_videoservcnt              | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_hlsnbrvideoreq            | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_hlsnbrvideoressucc        | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_hlsvideoressuccratio      | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_hlsinitbufferreq          | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_hlsinitbuffersucc         | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_hlsinitbuffersuccratio    | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_hlsinitbufferduration     | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_hlsavginitbufferduration  | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_hlsvideobufferduration    | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_hlsvideobuffercnt         | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_hlsavgvideobufferduration | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_hlsvideobufferservcnt     | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_hlsvideoservcnt           | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_hlsvideobufferrate        | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_hlsvideoserv0bufferrate   | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_hlsvideodloctets          | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_hlsvideodlduration        | BIGINT    | -1               | -1     | 8        | 8        |
| kpi_hlsavgvideodlrate         | DOUBLE    | -1               | -1     | 8        | 8        |
| kpi_nbrtcprelease             | BIGINT    | -1               | -1     | 8        | 8        |
| day                           | INT       | 78               | 0      | 4        | 4        |
| minute                        | CHAR(4)   | 24               | 0      | 4        | 4        |
+-------------------------------+-----------+------------------+--------+----------+----------+
Fetched 232 row(s) in 0.08s
[slave01:21000] > compute INCREMENTAL stats prestat.st_ct_app_hour partition (day=20180207 ,minute='0300');
Query: compute INCREMENTAL stats prestat.st_ct_app_hour partition (day=20180207 ,minute='0300')
+-------------------------------------------+
| summary                                   |
+-------------------------------------------+
| Updated 1 partition(s) and 230 column(s). |
+-------------------------------------------+
Fetched 1 row(s) in 6.29s

[slave01:21000] > show column stats st_ct_app_hour;
Query: show column stats st_ct_app_hour
+-------------------------------+-----------+------------------+--------+----------+-------------------+
| Column                        | Type      | #Distinct Values | #Nulls | Max Size | Avg Size          |
+-------------------------------+-----------+------------------+--------+----------+-------------------+
| timevalue                     | TIMESTAMP | 1                | -1     | 16       | 16                |
| rat                           | STRING    | 3                | -1     | 1        | 1                 |
| city                          | STRING    | 13               | -1     | 5        | 5                 |
| app_type_l1                   | STRING    | 0                | -1     | 0        | 0                 |
| app_type_l2                   | STRING    | 0                | -1     | 0        | 0                 |
| app_sub_type                  | STRING    | 883              | -1     | 5        | 3.802099943161011 |
| kpi_nbrdnsresreq              | BIGINT    | 41               | -1     | 8        | 8                 |
| kpi_nbrdnsressucc             | BIGINT    | 39               | -1     | 8        | 8                 |
| kpi_dnsresdelay               | DOUBLE    | 40               | -1     | 8        | 8                 |
| kpi_nbrtcpconn1streq          | BIGINT    | 179              | -1     | 8        | 8                 |
| kpi_nbrtcpconn1stsucc         | BIGINT    | 157              | -1     | 8        | 8                 |
| kpi_nbrtcpconn2ndsucc         | BIGINT    | 145              | -1     | 8        | 8                 |
| kpi_tcpconn1stdelay           | DOUBLE    | 862              | -1     | 8        | 8                 |
| kpi_tcpconn2nddelay           | DOUBLE    | 1800             | -1     | 8        | 8                 |
| kpi_tcpconndelay              | DOUBLE    | 2020             | -1     | 8        | 8                 |
| kpi_tcpulpacketcnt            | BIGINT    | 841              | -1     | 8        | 8                 |
| kpi_tcpdlpacketcnt            | BIGINT    | 864              | -1     | 8        | 8                 |
| kpi_tcpulretranscnt           | BIGINT    | 98               | -1     | 8        | 8                 |
| kpi_tcpdlretranscnt           | BIGINT    | 158              | -1     | 8        | 8                 |
| kpi_nbrtcpulrtt               | BIGINT    | 263              | -1     | 8        | 8                 |
| kpi_tcpulrttdelay             | DOUBLE    | 1417             | -1     | 8        | 8                 |
| kpi_nbrtcpdlrtt               | BIGINT    | 594              | -1     | 8        | 8                 |
| kpi_tcpdlrttdelay             | DOUBLE    | 3055             | -1     | 8        | 8                 |
| kpi_ultranoctets              | DOUBLE    | 5206             | -1     | 8        | 8                 |
| kpi_dltranoctets              | DOUBLE    | 5453             | -1     | 8        | 8                 |
| kpi_nbrwebreq                 | BIGINT    | 62               | -1     | 8        | 8                 |
| kpi_nbrwebressucc             | BIGINT    | 61               | -1     | 8        | 8                 |
| kpi_webresdelay               | DOUBLE    | 508              | -1     | 8        | 8                 |
| kpi_nbrwebopensucc            | BIGINT    | 55               | -1     | 8        | 8                 |
| kpi_webopendelay              | DOUBLE    | 795              | -1     | 8        | 8                 |
| kpi_webdlvalidoctets          | DOUBLE    | 425              | -1     | 8        | 8                 |
| kpi_webdlvaliddelay           | DOUBLE    | 404              | -1     | 8        | 8                 |
| kpi_web_over50kbcnt           | BIGINT    | 16               | -1     | 8        | 8                 |
| kpi_web_over5mbcnt            | BIGINT    | 0                | -1     | 8        | 8                 |
| kpi_web_less100kbpscnt        | BIGINT    | 2                | -1     | 8        | 8                 |
| kpi_web_100_200kbpscnt        | BIGINT    | 2                | -1     | 8        | 8                 |
| kpi_web_200_500kbpscnt        | BIGINT    | 2                | -1     | 8        | 8                 |
| kpi_web_500_1mbpscnt          | BIGINT    | 3                | -1     | 8        | 8                 |
| kpi_web_over1mbpscnt          | BIGINT    | 15               | -1     | 8        | 8                 |
| kpi_web_over2mbpscnt          | BIGINT    | 14               | -1     | 8        | 8                 |
| kpi_web_over3mbpscnt          | BIGINT    | 13               | -1     | 8        | 8                 |
| kpi_web_over4mbpscnt          | BIGINT    | 13               | -1     | 8        | 8                 |
| kpi_web_over5mbpscnt          | BIGINT    | 13               | -1     | 8        | 8                 |
| kpi_web_over0mscnt            | BIGINT    | 61               | -1     | 8        | 8                 |
| kpi_web_less500mscnt          | BIGINT    | 58               | -1     | 8        | 8                 |
| kpi_web_500_1scnt             | BIGINT    | 13               | -1     | 8        | 8                 |
| kpi_web_1_2scnt               | BIGINT    | 8                | -1     | 8        | 8                 |
| kpi_web_2_3scnt               | BIGINT    | 5                | -1     | 8        | 8                 |
| kpi_web_over3scnt             | BIGINT    | 9                | -1     | 8        | 8                 |
| kpi_nbrvideoreq               | BIGINT    | 10               | -1     | 8        | 8                 |
| kpi_nbrvideoressucc           | BIGINT    | 10               | -1     | 8        | 8                 |
| kpi_initbufferduration        | DOUBLE    | 103              | -1     | 8        | 8                 |
| kpi_initbuffercnt             | BIGINT    | 0                | -1     | 8        | 8                 |
| kpi_videobufferduration       | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_videobuffercnt            | BIGINT    | 0                | -1     | 8        | 8                 |
| kpi_videobufferservcnt        | BIGINT    | 0                | -1     | 8        | 8                 |
| kpi_videodloctets             | DOUBLE    | 69               | -1     | 8        | 8                 |
| kpi_videodlduration           | DOUBLE    | 69               | -1     | 8        | 8                 |
| kpi_dnsressuccratio           | DOUBLE    | 40               | -1     | 8        | 8                 |
| kpi_avgdnsresdelay            | DOUBLE    | 41               | -1     | 8        | 8                 |
| kpi_tcpconn1stratio           | DOUBLE    | 89               | -1     | 8        | 8                 |
| kpi_avgtcpconn1stdelay        | DOUBLE    | 1378             | -1     | 8        | 8                 |
| kpi_tcpconn2ndratio           | DOUBLE    | 83               | -1     | 8        | 8                 |
| kpi_avgtcpconn2nddelay        | DOUBLE    | 2403             | -1     | 8        | 8                 |
| kpi_tcpconnsuccratio          | DOUBLE    | 114              | -1     | 8        | 8                 |
| kpi_avgtcpconndelay           | DOUBLE    | 2464             | -1     | 8        | 8                 |
| kpi_tcpulretransratio         | DOUBLE    | 599              | -1     | 8        | 8                 |
| kpi_tcpdlretransratio         | DOUBLE    | 841              | -1     | 8        | 8                 |
| kpi_avgtcpulrttdelay          | DOUBLE    | 2062             | -1     | 8        | 8                 |
| kpi_avgtcpdlrttdelay          | DOUBLE    | 3459             | -1     | 8        | 8                 |
| kpi_tranoctets                | DOUBLE    | 486              | -1     | 8        | 8                 |
| kpi_webresratio               | DOUBLE    | 69               | -1     | 8        | 8                 |
| kpi_avgwebresdelay            | DOUBLE    | 717              | -1     | 8        | 8                 |
| kpi_nbrwebopenratio           | DOUBLE    | 62               | -1     | 8        | 8                 |
| kpi_avgwebopendelay           | DOUBLE    | 817              | -1     | 8        | 8                 |
| kpi_avgwebdlrate              | DOUBLE    | 438              | -1     | 8        | 8                 |
| kpi_web_e2e_excellentrate     | DOUBLE    | 21               | -1     | 8        | 8                 |
| kpi_web_e2e_goodrate          | DOUBLE    | 20               | -1     | 8        | 8                 |
| kpi_web_e2e_poorrate          | DOUBLE    | 13               | -1     | 8        | 8                 |
| kpi_web_e2e_promptnessrate    | DOUBLE    | 89               | -1     | 8        | 8                 |
| kpi_web_e2e_hysteresisrate    | DOUBLE    | 52               | -1     | 8        | 8                 |
| kpi_videoressuccratio         | DOUBLE    | 2                | -1     | 8        | 8                 |
| kpi_avginitbufferduration     | DOUBLE    | 107              | -1     | 8        | 8                 |
| kpi_avgvideobufferduration    | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_avgvideobuffercnt         | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_videobufferrate           | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_avgperminutebuffercnt     | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_avgvideodlrate            | DOUBLE    | 73               | -1     | 8        | 8                 |
| kpi_avgpergbbuffercnt         | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_web_over500kbpscnt        | DOUBLE    | 16               | -1     | 8        | 8                 |
| kpi_web_less200kbpscnt        | DOUBLE    | 2                | -1     | 8        | 8                 |
| kpi_web_less1mbpscnt          | DOUBLE    | 3                | -1     | 8        | 8                 |
| kpi_videoappdatas             | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_videouldatas              | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_videodldatas              | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_dns_over2scnt             | DOUBLE    | 16               | -1     | 8        | 8                 |
| kpi_tcp1st_over2scnt          | DOUBLE    | 5                | -1     | 8        | 8                 |
| kpi_tcp2nd_over2scnt          | DOUBLE    | 24               | -1     | 8        | 8                 |
| kpi_nbrhttpres1xx             | DOUBLE    | 5                | -1     | 8        | 8                 |
| kpi_nbrhttpres2xx             | DOUBLE    | 58               | -1     | 8        | 8                 |
| kpi_nbrhttpres3xx             | DOUBLE    | 16               | -1     | 8        | 8                 |
| kpi_nbrhttpres4xx             | DOUBLE    | 6                | -1     | 8        | 8                 |
| kpi_nbrhttpres5xx             | DOUBLE    | 2                | -1     | 8        | 8                 |
| kpi_nbrhttpres200             | DOUBLE    | 57               | -1     | 8        | 8                 |
| kpi_nbrhttpres206             | DOUBLE    | 16               | -1     | 8        | 8                 |
| kpi_nbrhttpres404             | DOUBLE    | 4                | -1     | 8        | 8                 |
| kpi_nbrhttpres505             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrsmallwebopensucc       | DOUBLE    | 49               | -1     | 8        | 8                 |
| kpi_dns_over2srate            | DOUBLE    | 33               | -1     | 8        | 8                 |
| kpi_tcp1st_over2srate         | DOUBLE    | 56               | -1     | 8        | 8                 |
| kpi_tcp2nd_over2srate         | DOUBLE    | 147              | -1     | 8        | 8                 |
| kpi_nbrimreq                  | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrimsucc                 | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_imsuccratio               | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrimloginreq             | DOUBLE    | 34               | -1     | 8        | 8                 |
| kpi_nbrimloginsucc            | DOUBLE    | 31               | -1     | 8        | 8                 |
| kpi_imloginsuccratio          | DOUBLE    | 36               | -1     | 8        | 8                 |
| kpi_imlogindelay              | DOUBLE    | 41               | -1     | 8        | 8                 |
| kpi_avgimlogindelay           | DOUBLE    | 40               | -1     | 8        | 8                 |
| kpi_nbrimtextreq              | DOUBLE    | 26               | -1     | 8        | 8                 |
| kpi_nbrimtextsucc             | DOUBLE    | 26               | -1     | 8        | 8                 |
| kpi_imtextsuccratio           | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_imtextdelay               | DOUBLE    | 40               | -1     | 8        | 8                 |
| kpi_avgimtextdelay            | DOUBLE    | 41               | -1     | 8        | 8                 |
| kpi_nbrimpictreq              | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_nbrimpictsucc             | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_impictsuccratio           | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_impictdelay               | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_avgimpictdelay            | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_nbrwebpostreq             | DOUBLE    | 92               | -1     | 8        | 8                 |
| kpi_nbrwebpostsucc            | DOUBLE    | 85               | -1     | 8        | 8                 |
| kpi_webpostsuccratio          | DOUBLE    | 147              | -1     | 8        | 8                 |
| kpi_webpostdelay              | DOUBLE    | 895              | -1     | 8        | 8                 |
| kpi_avgwebpostdelay           | DOUBLE    | 1063             | -1     | 8        | 8                 |
| kpi_nbrwebpostcompt           | DOUBLE    | 86               | -1     | 8        | 8                 |
| kpi_webpostcomptratio         | DOUBLE    | 147              | -1     | 8        | 8                 |
| kpi_webpostcompt50delay       | DOUBLE    | 1143             | -1     | 8        | 8                 |
| kpi_nbrwebpostcompt50         | DOUBLE    | 84               | -1     | 8        | 8                 |
| kpi_avgwebpostcompt50delay    | DOUBLE    | 1300             | -1     | 8        | 8                 |
| kpi_webpostupdatas50          | DOUBLE    | 40               | -1     | 8        | 8                 |
| kpi_webpostupdatas50delay     | DOUBLE    | 39               | -1     | 8        | 8                 |
| kpi_webpostupdatas50ratio     | DOUBLE    | 40               | -1     | 8        | 8                 |
| kpi_dnsformaterror            | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_dnsserverfailure          | DOUBLE    | 21               | -1     | 8        | 8                 |
| kpi_dnsnameerror              | DOUBLE    | 19               | -1     | 8        | 8                 |
| kpi_dnsnotimplemented         | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_dnsrefused                | DOUBLE    | 9                | -1     | 8        | 8                 |
| kpi_dnsnotres                 | DOUBLE    | 34               | -1     | 8        | 8                 |
| kpi_nbrhttpres100             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrhttpres101             | DOUBLE    | 5                | -1     | 8        | 8                 |
| kpi_nbrhttpres201             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrhttpres202             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrhttpres203             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrhttpres204             | DOUBLE    | 3                | -1     | 8        | 8                 |
| kpi_nbrhttpres205             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrhttpres300             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrhttpres301             | DOUBLE    | 3                | -1     | 8        | 8                 |
| kpi_nbrhttpres302             | DOUBLE    | 15               | -1     | 8        | 8                 |
| kpi_nbrhttpres303             | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_nbrhttpres304             | DOUBLE    | 6                | -1     | 8        | 8                 |
| kpi_nbrhttpres305             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrhttpres307             | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_nbrhttpres400             | DOUBLE    | 4                | -1     | 8        | 8                 |
| kpi_nbrhttpres401             | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_nbrhttpres402             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrhttpres403             | DOUBLE    | 4                | -1     | 8        | 8                 |
| kpi_nbrhttpres405             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrhttpres406             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrhttpres407             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrhttpres408             | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_nbrhttpres409             | DOUBLE    | 2                | -1     | 8        | 8                 |
| kpi_nbrhttpres410             | DOUBLE    | 2                | -1     | 8        | 8                 |
| kpi_nbrhttpres411             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrhttpres412             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrhttpres413             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrhttpres414             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrhttpres415             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrhttpres416             | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_nbrhttpres417             | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrhttpres500             | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_nbrhttpres501             | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_nbrhttpres502             | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_nbrhttpres503             | DOUBLE    | 2                | -1     | 8        | 8                 |
| kpi_nbrhttpres504             | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_nbrhttpresext             | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_nbrhttpnores              | DOUBLE    | 7                | -1     | 8        | 8                 |
| kpi_tcpullostpacketcnt        | DOUBLE    | 68               | -1     | 8        | 8                 |
| kpi_tcpdllostpacketcnt        | DOUBLE    | 217              | -1     | 8        | 8                 |
| kpi_tcpullostpacketratio      | DOUBLE    | 357              | -1     | 8        | 8                 |
| kpi_tcpdllostpacketratio      | DOUBLE    | 874              | -1     | 8        | 8                 |
| kpi_nbrservicepv              | DOUBLE    | 268              | -1     | 8        | 8                 |
| kpi_initbufferreq             | DOUBLE    | 10               | -1     | 8        | 8                 |
| kpi_initbuffersucc            | DOUBLE    | 10               | -1     | 8        | 8                 |
| kpi_initbuffersuccratio       | DOUBLE    | 10               | -1     | 8        | 8                 |
| kpi_nbrwebopenreq             | DOUBLE    | 56               | -1     | 8        | 8                 |
| kpi_videoserv0bufferrate      | DOUBLE    | 0                | -1     | 8        | 8                 |
| appunicode                    | STRING    | 1012             | -1     | 8        | 6.451200008392334 |
| app_type                      | STRING    | 19               | -1     | 2        | 1.649799942970276 |
| kpi_recorderreq               | BIGINT    | 0                | -1     | 8        | 8                 |
| kpi_recorderressucc           | BIGINT    | 0                | -1     | 8        | 8                 |
| kpi_recorderresratio          | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_recorderresdelay          | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_avgrecorderresdelay       | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_uporderreq                | BIGINT    | 0                | -1     | 8        | 8                 |
| kpi_uporderressucc            | BIGINT    | 0                | -1     | 8        | 8                 |
| kpi_uporderresratio           | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_uporderresdelay           | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_avguporderresdelay        | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_nbrtcplost                | BIGINT    | 57               | -1     | 8        | 8                 |
| kpi_tcplostratio              | DOUBLE    | 238              | -1     | 8        | 8                 |
| kpi_videoservcnt              | BIGINT    | 6                | -1     | 8        | 8                 |
| kpi_hlsnbrvideoreq            | BIGINT    | 6                | -1     | 8        | 8                 |
| kpi_hlsnbrvideoressucc        | BIGINT    | 6                | -1     | 8        | 8                 |
| kpi_hlsvideoressuccratio      | DOUBLE    | 1                | -1     | 8        | 8                 |
| kpi_hlsinitbufferreq          | BIGINT    | 0                | -1     | 8        | 8                 |
| kpi_hlsinitbuffersucc         | BIGINT    | 0                | -1     | 8        | 8                 |
| kpi_hlsinitbuffersuccratio    | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_hlsinitbufferduration     | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_hlsavginitbufferduration  | DOUBLE    | 0                | -1     | 8        | 8                 |
| kpi_hlsvideobufferduration    | DOUBLE    | 4                | -1     | 8        | 8                 |
| kpi_hlsvideobuffercnt         | BIGINT    | 2                | -1     | 8        | 8                 |
| kpi_hlsavgvideobufferduration | DOUBLE    | 4                | -1     | 8        | 8                 |
| kpi_hlsvideobufferservcnt     | DOUBLE    | 2                | -1     | 8        | 8                 |
| kpi_hlsvideoservcnt           | DOUBLE    | 6                | -1     | 8        | 8                 |
| kpi_hlsvideobufferrate        | DOUBLE    | 4                | -1     | 8        | 8                 |
| kpi_hlsvideoserv0bufferrate   | DOUBLE    | 4                | -1     | 8        | 8                 |
| kpi_hlsvideodloctets          | BIGINT    | 20               | -1     | 8        | 8                 |
| kpi_hlsvideodlduration        | BIGINT    | 20               | -1     | 8        | 8                 |
| kpi_hlsavgvideodlrate         | DOUBLE    | 20               | -1     | 8        | 8                 |
| kpi_nbrtcprelease             | BIGINT    | 205              | -1     | 8        | 8                 |
| day                           | INT       | 78               | 0      | 4        | 4                 |
| minute                        | CHAR(4)   | 24               | 0      | 4        | 4                 |
+-------------------------------+-----------+------------------+--------+----------+-------------------+
Fetched 232 row(s) in 0.08s
[slave01:21000] >



建议读官方文档

Syntax:
CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name[COMMENT 'database_comment']
[LOCATION hdfs_path];


老农民挖数据
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Impala中的刷新元数据和刷新表
默硕的博客
04-09 460
主要用于表中元数据未修改，数据的修改，例如insert into、load data、alter table add partition、llter table drop partition等，refresh是用于刷新某个表或者某个分区的数据信息，它会重用之前的表元数据，仅仅执行文件刷新操作，它能够检测到表中分区的增加和减少，invalidate metadata是用于刷新全库或者某个表的元数据，包括表的元数据和表内的文件数据，它会首先清楚表的缓存，
Impala数据刷新
L, there!
08-21 1632
1.refresh refresh 用于刷新某个表或者某个分区的数据信息，它会重用之前的表元数据，仅仅执行文件刷新操作。 主要用于表中元数据未修改，数据的修改，例如insert into、load data、alter table add partition、llter table drop partition等，如果直接修改表的hdfs文件（增加、删除或者重命名）也需要指定refresh刷...
正确使用Impala的invalidate metadata与refresh语句
LittleMagic's Blog
10-06 1404
在Impala中，invalidate metadata与refresh语句都可以用来刷新表，但它们本质上还是不同的。本文简要分析一下，并说明它们应该在什么情况下使用。 Impala on Hive介绍 我们一般会采用传统的MySQL或PostgreSQL数据库作为Hive的Metastore（元数据存储）组件。在CDH中默认是MySQL，我们可以通过show tables in ...
VC查看某IP是否可以ping通
路楷的专栏
05-08 1284
BOOL CheckIPReachable(LPCTSTR strIPAddress)  {      char strIP[100]; #ifdef UNICODE      WideCharToMultiByte(CP_ACP,0,strIPAddress,(int)_tcslen(strIPAddress)+1,strIP,sizeof(strIP)/sizeof(cha
impala的刷新两种刷新方式
weixin_45108435的博客
04-12 1675
impala的刷新两种刷新方式
小知识点 clear、refresh、free三者清空内表
qq_53645728的博客
02-01 452
【代码】小知识点 clear free。
dbeaver impala jdbc连接包
01-20
标题 "dbeaver impala jdbc连接包" 涉及到的是在数据管理工具DBeaver中连接Impala数据库所必需的Java Database Connectivity (JDBC)驱动。Impala是Cloudera Data Hub (CDH)中的一种分布式分析引擎，用于处理大规模的...
impala-2.9.pdf
10-12
Apache Impala 指南 Apache Impala 是一个基于 Apache Hadoop 的查询引擎，旨在提供高效、可扩展的数据分析解决方案。下面是 Impala 的重要知识点： Impala 的优点 Impala 的主要优点包括： * 高性能查询：...
impala_jdbc.zip
12-28
此外，合理的分区策略和预计算（materialized views）也能显著提升查询效率。 2. **安全考虑**：如果你的环境需要安全连接，如SSL加密或Kerberos认证，需要在连接URL中指定相应的参数，并确保系统已正确配置安全...
impala connection test
07-19
在实际的"impala connection test"中，我们可能需要编写一个脚本来尝试连接到Impala服务器，并执行一个简单的查询，如检查当前数据库中的表。如果连接成功且查询返回预期结果，则表明连接测试通过。 例如，可以创建...
impala connection
最新发布
07-19
impala connection
Impala介绍，Impala架构，Impala安装，impala Shell ，分区创建，refresh,load数据，获取数据的元数据
涂作权的博客
10-17 1482
1 Impala Impala是Cloudera公司主导开发的新型查询系统，它提供SQL语义，能查询存储在Hadoop的HDFS和HBASE中的PB级大数据。已有的Hive系统虽然也提供了SQL语义，但由于Hive底层执行使用的是MapReduce引擎，仍然是一个批处理过程，难以满足查询的交互性。相比之下，Impala的最大特点也是最大卖点就是它的快速。 Impala到底是什么？ Impala是用...
Impala - 刷新表的两种方式invalidate metadata和refresh
摸鱼同学的博客
09-08 4197
impala刷新表有两种方式 invalidate metadata和refresh： invalidate metadata invalidate metadata：刷新元数据和文件 -- 刷新所有库中的所有表 invalidate metadata; -- 刷新指定库的指定表 invalidate metadata tablename; refresh refresh：不刷新元数据，只刷新文件 -- 刷新指定表 refresh tablename -- 刷新指定表的分区
mysql refresh table,数据透视表“ RefreshTable”与“更新”方法
weixin_36349918的博客
01-26 675
I want to programmatically refresh all the Pivot Tables in a given Worksheet of my Excel Workbook. After searching here on StackOverflow, I found this question where the answer suggests using eitherTh...
[Impala基础]-- impala表的分区(CDH5.7以上版本)
欢迎来到我的博客，一起探索代码里的世界！
11-20 1万+
NO1 基本描述      默认情况下，表的所有数据文件位于单个目录中。 分区是一种基于一个或多个列的值在加载期间物理划分数据以加快测试这些列的查询的技术。 例如，对于在年份列上分区的school_records表，对于每个不同的年值具有单独的数据目录，并且该年的所有数据存储在该目录中的数据文件中。 包括WHERE条件（例如YEAR = 1966，YEAR IN（1989,1999）或YEAR ...
impala常见优化策略
zhangsq1319
05-25 691
impala常见优化策略 分区不能超过3w多 要执行compute stats xxx 表 join时，把小表写前面，会把小表广播到其他节点。 选择parquert 格式存储。 刷新Impala invalidate metadata时，跟上表，禁止直接执行invalidate metadata ...
Impala中的invalidate metadata和refresh
热门推荐
Hello World
05-27 3万+
前言Impala采用了比较奇葩的多个impalad同时提供服务的方式，并且它会由catalogd缓存全部元数据，再通过statestored完成每一次的元数据的更新到impalad节点上，Impala集群会缓存全部的元数据，这种缓存机制就导致通过其他手段更新元数据或者数据对于Impala是无感知的，例如通过hive建表，直接拷贝新的数据到HDFS上等，Impala提供了两种机制来实现元数据的更新，分
impala元数据放到mysql_impala两种方式同步hive元数据
weixin_31679307的博客
02-07 399
基础知识Impala采用多个impalad(impala的核心进程)同时提供服务的方式，并且它会由catalogd(元数据管理和元数据存储)缓存全部元数据，再通过statestored(状态管理进程)完成每一次的元数据的更新到impalad节点上，Impala集群会缓存全部的元数据。Impala在传统的MySQL或PostgreSQL数据库称为Metastore，Hive也在其相同的数据库上保存此...
Impala中的Invalidate Metadata和Refresh
王佩的CSDN博客
03-15 2724
Impala中有两种同步元数据的方式:INVALIDATE METADATA和REFRESH。 使用Impala执行的DDL操作,不需要使用任何INVALIDATE METADATA / REFRESH命令。CatalogServer会将这种DDL元数据变化通过StateStore增量同步到集群中的所有Impalad节点。 在Impala之外，使用Hive或其他Hive客户端(如Spark SQL...
impala hive插入分区表 权限问题
05-24
在 Impala 中插入分区表时，需要确保当前用户拥有合适的权限。如果出现权限问题，可以尝试以下步骤： 1. 确认当前用户是否具有对分区表的 INSERT 权限。 2. 如果当前用户没有足够的权限，则可以向管理员请求授予 INSERT 权限。 3. 确认分区表的 HDFS 目录权限是否正确。如果 HDFS 目录的权限不正确，则可以使用以下命令更改目录权限： ``` hdfs dfs -chmod -R 775 /path/to/hdfs/dir ``` 4. 确认 Impala 守护进程运行的用户是否具有足够的权限访问 HDFS 目录。如果 Impala 守护进程运行的用户没有足够的权限，则可以修改 Impala 守护进程运行的用户或使用以下命令更改目录权限： ``` hdfs dfs -chown -R impala /path/to/hdfs/dir ``` 如果以上步骤无法解决权限问题，请向管理员寻求更多帮助。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值