查询语句 select MotorVehicleList.MotorVehicleObject.InfoKind from videoslicebak 查询出来的结果如下:
0: jdbc:hive2://localhost:10000> select MotorVehicleList.MotorVehicleObject.InfoKind from videoslicebak;
+-----------+--+
| InfoKind |
+-----------+--+
| [2] |
| [2] |
| [2,2] |
+-----------+--+
3 rows selected (0.181 seconds)
加入查询条件 select MotorVehicleList.MotorVehicleObject.InfoKind from videoslicebak where MotorVehicleList.MotorVehicleObject.InfoKind=2;
然后报类型不匹配:
0: jdbc:hive2://localhost:10000> select MotorVehicleList.MotorVehicleObject.InfoKind from videoslicebak where MotorVehicleList.MotorVehicleObject.InfoKind=2;
Error: org.apache.spark.sql.AnalysisException: cannot resolve '(videoslicebak.`MotorVehicleList`.`MotorVehicleObject`.`InfoKind` = 2)' due to data type mismatch: differing types in '(videoslicebak.`MotorVehicleList`.`MotorVehicleObject`.`InfoKind` = 2)' (array and int).; line 1 pos 77 (state=,code=0)
请高手们帮忙,这种类型结构应该怎么写where条件?