hive sql插入一行数据_hive分区表插入一条测试数据

1.show create table tb_cdr;

+-------------------------------------------------------+--+

|                    createtab_stmt                     |

+-------------------------------------------------------+--+

| CREATE TABLE `tb_cdr`(                                |

|   `begintime` bigint,                                 |

|   `usernum` string,                                   |

|   `homearea` string,                                  |

|   `relatenum` string,                                 |

|   `relatehomeac` string,                              |

|   `imsi` string,                                      |

|   `imei` string,                                      |

|   `curarea` string,                                   |

|   `neid` string,                                      |

|   `lai` int,                                          |

|   `ci` string,                                        |

|   `longitude` float,                                  |

|   `latitude` float,                                   |

|   `billtype` string,                                  |

|   `calltype` string,                                  |

|   `dtmf` string,                                      |

|   `callduration` int,                                 |

|   `cause` string,                                     |

|   `rlgtime` bigint,                                   |

|   `alerttime` bigint,                                 |

|   `connecttime` bigint,                               |

|   `disconnecttime` bigint,                            |

|   `sid` string,                                       |

|   `idflag` int,                                       |

|   `rawrelatenum` string,                              |

|   `redirflag` int,                                    |

|   `origcalledno` string,                              |

|   `disconnecttype` int,                               |

|   `newlai` int,                                       |

|   `newci` string,                                     |

|   `newlongitude` float,                               |

|   `newlatitude` float,                                |

|   `tmsi` string,                                      |

|   `spcode` string,                                    |

|   `voiceflag` string,                                 |

|   `voicekeya` string,                                 |

|   `voicekeyb` s