《Hive 编程专题三 : 列引用之算术组合.docx》由会员分享,可在线阅读,更多相关《Hive 编程专题三 : 列引用之算术组合.docx(2页珍藏版)》请在金锄头文库上搜索。
1、Hive 编程专题三 : 列引用之算术组合环境:Hive:2.7.7OracleSQLDeveloperClouderaJDBCDriver案例:selectobject_id,schema_id,object_id+schema_id,object_id-schema_id,object_id*schema_id,object_id/schema_id,object_id%schema_id,object_id|schema_id-,object_id&schema_id,object_idschema_id,schema_idfromtblobj2limit10异常:1. 在运行被注释掉的
2、表达式 object_id & schema_id 时,出现输入 schema_id 的对话框:image解决方案:selectobject_id,schema_id,object_id+schema_id,object_id-schema_id,object_id*schema_id,object_id/schema_id,object_id%schema_id,object_id|schema_id,object_id&(schema_id),object_idschema_id,schema_idfromtblobj2limit10解决问题的关键在于 object_id & (schema_id)