[PHOENIX-1513] Could not find or load main class sqlline.SqlLine: Bad phoenix_utils.phoenix_client_jar path

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.2.0

Environment

local machine, hbase-0.94.24, phoenix-3.2.0-bin

• Assignee: Unassigned
• Reporter: Brian Gilreath
• Created: 08/Dec/14 23:24
• Updated: 21/Nov/15 02:16
• Resolved: 26/Jan/15 22:47

Description

When executing sqlline.py for hadoop1, I receive this error:
Error: Could not find or load main class sqlline.SqlLine

My set up is simply:
export HBASE_HOME=~/hbase-0.94.24
$HBASE_HOME/bin/start-hbase.sh
export HBASE_CONF_PATH=~/$HBASE_HOME/conf
~/phoenix-3.2.0-bin/hadoop1/bin/sqlline.py localhost

It works when I run with:
~/phoenix-3.1.0-bin/hadoop1/bin/sqlline.py localhost

After digging into it a little bit, it appears that it can't find the client jar for execution ( phoenix_utils.phoenix_client_jar returns an empty string )

Temporarily, I remedied it by manually executing the corrected java command:
java -cp "/User/youruser/hbase-0.94.24/conf/:/User/youruser/phoenix-3.2.0-bin/hadoop1/bin/../phoenix-3.2.0-client-hadoop1.jar" -Dlog4j.configuration=file:/Users/youruser/phoenix-3.2.0-bin/hadoop1/bin/log4j.properties sqlline.SqlLine -d org.apache.phoenix.jdbc.PhoenixDriver -u jdbc:phoenix:localhost -n none -p none --color=true --fastConnect=false --verbose=true --isolation=TRANSACTION_READ_COMMITTED