有没有办法用参数的sql脚本运行impala shell？ [英] Is there any way to run impala shell with sql script with parameters？

问题描述

有什么办法可以用参数的SQL脚本运行impala shell吗？

Is there any way to run impala shell with SQL script with parameters?

例如：

For example:

impala-shell -f /home/john/sql/load.sql /dir1/dir2/dir3/data_file

出现错误：

I got errors:

错误，无法解析参数-f / home / john /sql/load.sql/dir1/dir2/dir3/data_file

Error, could not parse arguments "-f /home/john/sql/load.sql /dir1/dir2/dir3/data_file"

推荐答案

不，你可以使用 -f 指定一个sql语句文件，但它不需要参数文件。有关更多详细信息，请参阅impala-shell文档：
< a href =http://www.cloudera.com/content/cloudera/en/documentation/core/latest/topics/impala_impala_shell.html =nofollow> http://www.cloudera.com/content/ cloudera / en / documentation / core / latest / topics / impala_impala_shell.html

No, you can specify a file of sql statements with -f, but it does not take a file of parameters. See the impala-shell documentation for more details: http://www.cloudera.com/content/cloudera/en/documentation/core/latest/topics/impala_impala_shell.html

这篇关于有没有办法用参数的sql脚本运行impala shell？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！