I'm trying to execute hplsql scripts on HDP 2.5.3. However, I'm not able to instruct hplsql to read the config file from the current directory.
Is there something I've missed?
hplsql version: HPL/SQL 0.3.31
$ hplsql -trace -e "select count(*) from agg"
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/hdp/184.108.40.206-37/hive2/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/hdp/220.127.116.11-37/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]Configuration file: jar:file:/usr/hdp/18.104.22.168-37/hive2/lib/hive-hplsql-22.214.171.124.5.3.0-37.jar!/hplsql-site.xml
From what location are you invoking hplsql shell? If you have hplsql-site.xml in current directory, it should take precedence over default hplsql-site.xml file under lib folder. As an alternative you can try using SET command once you are inside shell to set parameters.