Skip to main content
 首页 » 编程设计

python之使用 impyla 执行时如何在配置单元查询中传递参数

2024年12月31日7cloudgamer

我提到了 How to use variables in SQL statement in Python?

但无法得到答案。

我正在尝试您的建议,但出现此错误 - :(

tbl_nm = 'EMPLOYEE_TABLE' 
 
con.execute('select max(emp_id) from schema.?', tbl_nm) 

出现以下错误:

Traceback (most recent call last): File "", line 1, in File "/usr/local/lib/python2.7/site-packages/impala/hiveserver2.py", line 302, 
 
in execute configuration=configuration) File "/usr/local/lib/python2.7/site-packages/impala/hiveserver2.py", line 343, 
 
in execute_async self._execute_async(op) File "/usr/local/lib/python2.7/site-packages/impala/hiveserver2.py", line 362, 
 
in _execute_async operation_fn() File "/usr/local/lib/python2.7/site-packages/impala/hiveserver2.py", line 334, 
 
in op parameters) File "/usr/local/lib/python2.7/site-packages/impala/interface.py", line 267, 
 
in _bind_parameters 
 
raise ProgrammingError("Query parameters argument should be a " 
impala.error.ProgrammingError: Query parameters argument should be a list, tuple, or dict object 
 
> 

请您参考如下方法:

建议您将查询作为字符串存储到变量中,然后将其传递给执行方法,而不是直接将原始配置单元查询传递给执行方法。

在你的情况下:

tbl_nm = 'EMPLOYEE_TABLE' 
query = "select max(emp_id) from schema.{}".format(tbl_nm) 
con.execute(query) 

如果这有帮助,请告诉我。