在hive中创建表遇到的问题

热爱大数据的少年 2018-04-04 05:47:38
以下是一行日志文件:
{"created_at":"1521446420","device_status":{"data":{"battery":63.470587999999999,"batteryVoltage":21.469999999999999,"charge":false,"charger":0,"chargerCurrent":-0.011719,"chargerStatus":false,"chargerVoltage":0.016,"detailedBatteryVoltageAdc":21480,"detailedBrakerDown":true,"detailedChargerCurrentAdc":16445,"detailedChargerVoltageAdc":16,"detailedDi":0,"detailedDo":0,"detailedRelay":86,"detailedRemoteController":0,"emergency":false,"emergencyStop":false,"inletValve":true,"mileage":0,"mileageLeft":0,"mileageRight":0,"navigationSpeedLevel":2,"outletValve":false,"playPathSpeedLevel":2,"remainingTime":31735.294118000002,"speed":0,"statusUpdatedAt":1521446420,"totalMileage":418.48504000000946,"uptime":7835},"errorCode":"","msg":"successed","successed":true},"health_status":{"3gCard":false,"cameraNotTrigger":true,"deviceTopic":true,"healthTopic":true,"imuBoard":true,"internetConnection":false,"laserNotTrigger":true,"laserTopic":true,"leftMotor":true,"odomTopic":true,"powerBoard":true,"protectorNotTrigger":true,"protectorTopic":true,"rightMotor":true,"softdog":true,"ultrasonic0":true,"ultrasonic1":true,"ultrasonic2":true,"ultrasonic3":true,"ultrasonic4":true,"ultrasonic5":true,"ultrasonicBoard":true,"ultrasonicNotTrigger":true,"usbwifi":true},"initialize_status":{"currentInitPoint":"Current","currentMap":"company"},"os_status":{"cpu_used_percent":"73%","disk_avail":"3.5GB","disk_total":"26.6GB","disk_used_percent":"86%","memory_avail":"552MB","memory_total":"1.8GB","memory_used_percent":"70%"},"position":{"angle":30.662454064325779,"gridPosition":{"x":308,"y":293},"mapInfo":{"gridHeight":544,"gridWidth":416,"originX":-14.4,"originY":-16,"resolution":0.05000000074505806},"worldPosition":{"orientation":{"w":0.96441346057625299,"x":0,"y":0,"z":0.26439870850542407},"position":{"x":1.0424475116099785,"y":-1.3135347300179232,"z":0}}},"product_id":"GS-SR-0001-0002-0000-0016","work_status":{"data":{"data_status":{"unfilled_paths":[]},"task_status":{"map":{"DIYPngName":"","createdAt":"2017-12-02 17:53:53","dataFileName":"9145fecc-1439-413a-97d1-dca6dd708864.data","extendDataFileName":"fa78a06f-e1a3-4c9d-8e74-7574dc5d1e4a.exdata","id":"20fedfd4-c63f-4004-b753-cc74a006fe38","lethalPgmName":"7b12cbd6-b82f-4541-a913-efdb0118dc9f.pgm","lethalPngName":"cffe7729-21ef-47be-a97f-c391300ee0cb.png","mapInfo":{"gridHeight":544,"gridWidth":416,"originX":-14.4,"originY":-16,"resolution":0.05000000074505806},"name":"company","obstacleFileName":"a5505731-dc8e-443f-8994-c7547bb83a59.json","pgmFileName":"d545d546-f7e6-45fd-a673-8b485fe29120.pgm","pngFileName":"904963be-6ba1-48bd-9ad1-90c38fe62698.png","slopeFileName":"","yamlFileName":"8e04e9d6-6f33-4ef4-858e-79a2d70f0095.yaml"},"task":null,"task_queue":null},"work_status":{"current_map_name":"","current_path_name":"","map":null,"work_type":"IDLE","work_type_id":7}},"errorCode":"","msg":"successed","successed":true}}

以下建表语句:
create table robot_status_json(created_at string,device_status struct<data:struct<battery:double,batteryVoltage:double,charge:boolean,charger:int,chargerCurrent:double,chargerStatus:boolean,chargerVoltage:double,detailedBatteryVoltageAdc:int,detailedBrakerDown:boolean,detailedChargerCurrentAdc:int,detailedChargerVoltageAdc:int,detailedDi:int,detailedDo:int,detailedRelay:int,detailedRemoteController:int,emergency:boolean,emergencyStop:boolean,inletValue:boolean,mileage:int,mileageLeft:int,mileageRight:int,navigationSpeedLevel:int,outletValue:boolean,playPathSpeedLevel:int,remainingTime:double,speed:int,statusUpdatedAt:int,totalMileage:float,uptime:int>,errorCode:string,msg:string,successed:boolean>,health_status struct<3gCard:boolean,cameraNotTrigger:boolean,deviceTopic:boolean,healthTopic:boolean,imuBoard:boolean,internetConnection:boolean,laserNotTrigger:boolean,laserTopic:boolean,leftMotor:boolean,odomTopic:boolean,powerBoard:boolean,protectorNotTrigger:boolean,protectorTopic:boolean,rightMotor:boolean,softdog:boolean,ultrasonic0:boolean,ultrasonic1:boolean,ultrasonic2:boolean,ultrasonic3:boolean,ultrasonic4:boolean,ultrasonic5:boolean,ultrasonicBoard:boolean,ultrasonicNotTrigger:boolean,usbwifi:boolean>,initialize_status struct<currentInitPoint:string,currentMap:string>,os_status struct<cpu_used_percent:string,disk_avail:string,disk_total:string,disk_used_percent:string,memory_avail:string,memory_total:string,memory_used_percent:string>,position struct<angle:double,gridposition:struct<x:int,y:int>,mapInfo:struct<gridHeight:int,gridWidth:int,originX:double,originY:double,resolution:double>,worldPosition:struct<orientation:struct<w:double,x:double,y:double,z:double>,position:struct<x:double,y:double,z:double>>>,product_id string,work_status struct<data:struct<data_status:struct<unfilled_path:string>,task_status:struct<map:struct<DIYPngName:string,createdAt:string,dataFileName:string,extendDataFileName:string,id:string ,lethalPgmName:string,lethalPngName:string,mapInfo:struct<gridHeight:double,gridWidth:double,originX:double,originY:double,resolution:double>,name:string,obstacleFileName:string,pgmFileName:string,pngFileName:string,slopeFileName:string,yamlFileName:string>,task:string,task_queue:string>,work_status:struct<current_map_name:string,current_path_name:string,map:string,work_type:string,work_type_id:int>>,errorCode:string,msg:tring,successed:boolean>)row format serde 'org.openx.data.jsonserde.JsonSerDe'stored as textfile;

在见表的过程中在work_status struct<data:struct<data_status:struct<unfilled_path:string>,task_status:struct<map:struct<DIYPngName:string,createdAt:string,dataFileName:string中的ask_status:struct<map报错是什么原因呢,整理完逻辑感觉没什么毛病。
...全文
310 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复

20,808

社区成员

发帖
与我相关
我的任务
社区描述
Hadoop生态大数据交流社区,致力于有Hadoop,hive,Spark,Hbase,Flink,ClickHouse,Kafka,数据仓库,大数据集群运维技术分享和交流等。致力于收集优质的博客
社区管理员
  • 分布式计算/Hadoop社区
  • 涤生大数据
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧