hive中的struct的4层嵌套出现的问题,那位大神帮看看什么原因



{"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}}

以上是我需要处理的一行的json格式日志。

创建表的内容如下:

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;    



在hive中创建表的时候跑到这一段的时候,但我感觉没错。
报错的地方:
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


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值