# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
############################################################################
import os
import subprocess
import sys
import phoenix_utils
phoenix_utils.setPath()
args = phoenix_utils.shell_quote(sys.argv[1:])
# HBase configuration folder path (where hbase-site.xml reside) for
# HBase/Phoenix client side property override
hbase_config_path = os.getenv('HBASE_CONF_DIR', phoenix_utils.current_dir)
java_home = os.getenv('JAVA_HOME')
# load hbase-env.??? to extract JAVA_HOME, HBASE_PID_DIR, HBASE_LOG_DIR
hbase_env_path = None
hbase_env_cmd = None
if os.name == 'posix':
hbase_env_path = os.path.join(hbase_config_path, 'hbase-env.sh')
hbase_env_cmd = ['bash', '-c', 'source %s && env' % hbase_env_path]
elif os.name == 'nt':
hbase_env_path = os.path.join(hbase_config_path, 'hbase-env.cmd')
if os.name != 'nt':
os.system("reset")
atexit.register(kill_child)
phoenix_utils.setPath()
if len(sys.argv) < 2:
print "Zookeeper not specified. \nUsage: sqlline.py <zookeeper> \
<optional_sql_file> \nExample: \n 1. sqlline.py localhost:2181:/hbase \n 2. sqlline.py \
localhost:2181:/hbase ../examples/stock_symbol.sql"
sys.exit()
sqlfile = ""
if len(sys.argv) > 2:
sqlfile = "--run=" + phoenix_utils.shell_quote([sys.argv[2]])
# HBase configuration folder path (where hbase-site.xml reside) for
# HBase/Phoenix client side property override
hbase_config_path = os.getenv('HBASE_CONF_DIR', phoenix_utils.current_dir)
java_home = os.getenv('JAVA_HOME')
# load hbase-env.??? to extract JAVA_HOME, HBASE_PID_DIR, HBASE_LOG_DIR
hbase_env_path = None
hbase_env_cmd = None
if os.name == 'posix':
hbase_env_path = os.path.join(hbase_config_path, 'hbase-env.sh')
hbase_env_cmd = ['bash', '-c', 'source %s && env' % hbase_env_path]
elif os.name == 'nt':
hbase_env_path = os.path.join(hbase_config_path, 'hbase-env.cmd')
# Parse the args
args=parser.parse_args()
zookeeper = args.zookeepers
sqlfile = args.sqlfile
# HBase configuration folder path (where hbase-site.xml reside) for
# HBase/Phoenix client side property override
hbase_config_path = os.getenv('HBASE_CONF_DIR', phoenix_utils.current_dir)
if sqlfile and not os.path.isfile(sqlfile):
parser.print_help()
sys.exit(-1)
if sqlfile:
sqlfile = "--run=" + phoenix_utils.shell_quote([sqlfile])
java_home = os.getenv('JAVA_HOME')
# load hbase-env.??? to extract JAVA_HOME, HBASE_PID_DIR, HBASE_LOG_DIR
hbase_env_path = None
hbase_env_cmd = None
if os.name == 'posix':
hbase_env_path = os.path.join(hbase_config_path, 'hbase-env.sh')
hbase_env_cmd = ['bash', '-c', 'source %s && env' % hbase_env_path]
elif os.name == 'nt':
hbase_env_path = os.path.join(hbase_config_path, 'hbase-env.cmd')
hbase_env_cmd = ['cmd.exe', '/c', 'call %s & set' % hbase_env_path]
if not hbase_env_path or not hbase_env_cmd:
print >> sys.stderr, "hbase-env file unknown on platform %s" % os.name
sys.exit(-1)
phoenix_utils.hadoop_common_jar,
phoenix_utils.hadoop_hdfs_jar ]
classpath = os.pathsep.join(classpath_components)
# Inline SQL. SQLLine offers no native support.
if options.evaluate:
from tempfile import NamedTemporaryFile
f = NamedTemporaryFile(delete=False)
tempFile = f.name
f.write(options.evaluate)
f.close()
options.run = tempFile
# Special quoting.
if options.run:
options.run = phoenix_utils.shell_quote([options.run])
options.zookeeper = phoenix_utils.shell_quote([options.zookeeper])
# Build the Java command line.
option_hash = dict((x, eval("options.%s" % x)) for x in automatic)
other_options = " ".join([ "--%s=%s" % (x, option_hash[x]) for x in automatic if option_hash[x]])
java_cmd = 'java -cp "' + classpath + \
'" -Dlog4j.configuration=file:' + os.path.join(phoenix_utils.current_dir, "log4j.properties") + \
" sqlline.SqlLine -d org.apache.phoenix.jdbc.PhoenixDriver " + \
" -u jdbc:phoenix:" + options.zookeeper + \
" -n none -p none --isolation=TRANSACTION_READ_COMMITTED " + \
other_options
childProc = subprocess.Popen(java_cmd, shell=True)
# Wait for child process exit
(output, error) = childProc.communicate()
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
############################################################################
from __future__ import print_function
from phoenix_utils import tryDecode
import os
import subprocess
import sys
import phoenix_utils
phoenix_utils.setPath()
args = phoenix_utils.shell_quote(sys.argv[1:])
# HBase configuration folder path (where hbase-site.xml reside) for
# HBase/Phoenix client side property override
hbase_config_path = phoenix_utils.hbase_conf_dir
java_home = os.getenv('JAVA_HOME')
# load hbase-env.??? to extract JAVA_HOME, HBASE_PID_DIR, HBASE_LOG_DIR
hbase_env_path = None
hbase_env_cmd = None
if os.name == 'posix':
hbase_env_path = os.path.join(hbase_config_path, 'hbase-env.sh')
hbase_env_cmd = ['bash', '-c', 'source %s && env' % hbase_env_path]
elif os.name == 'nt':
hbase_env_path = os.path.join(hbase_config_path, 'hbase-env.cmd')
if os.name != 'nt':
os.system("reset")
atexit.register(kill_child)
phoenix_utils.setPath()
if len(sys.argv) < 2:
print "Zookeeper not specified. \nUsage: sqlline.py <zookeeper> \
<optional_sql_file> \nExample: \n 1. sqlline.py localhost:2181:/hbase \n 2. sqlline.py \
localhost:2181:/hbase ../examples/stock_symbol.sql"
sys.exit()
sqlfile = ""
if len(sys.argv) > 2:
sqlfile = "--run=" + phoenix_utils.shell_quote([sys.argv[2]])
# HBase configuration folder path (where hbase-site.xml reside) for
# HBase/Phoenix client side property override
hbase_config_path = os.getenv('HBASE_CONF_DIR', phoenix_utils.current_dir)
java_home = os.getenv('JAVA_HOME')
# load hbase-env.??? to extract JAVA_HOME, HBASE_PID_DIR, HBASE_LOG_DIR
hbase_env_path = None
hbase_env_cmd = None
if os.name == 'posix':
hbase_env_path = os.path.join(hbase_config_path, 'hbase-env.sh')
hbase_env_cmd = ['bash', '-c', 'source %s && env' % hbase_env_path]
elif os.name == 'nt':
hbase_env_path = os.path.join(hbase_config_path, 'hbase-env.cmd')
# Parse the args
args = parser.parse_args()
zookeeper = args.zookeepers
sqlfile = args.sqlfile
# HBase configuration folder path (where hbase-site.xml reside) for
# HBase/Phoenix client side property override
hbase_config_path = os.getenv('HBASE_CONF_DIR', phoenix_utils.current_dir)
if sqlfile and not os.path.isfile(sqlfile):
parser.print_help()
sys.exit(-1)
if sqlfile:
sqlfile = "--run=" + phoenix_utils.shell_quote([sqlfile])
java_home = os.getenv('JAVA_HOME')
# load hbase-env.??? to extract JAVA_HOME, HBASE_PID_DIR, HBASE_LOG_DIR
hbase_env_path = None
hbase_env_cmd = None
if os.name == 'posix':
hbase_env_path = os.path.join(hbase_config_path, 'hbase-env.sh')
hbase_env_cmd = ['bash', '-c', 'source %s && env' % hbase_env_path]
elif os.name == 'nt':
hbase_env_path = os.path.join(hbase_config_path, 'hbase-env.cmd')
hbase_env_cmd = ['cmd.exe', '/c', 'call %s & set' % hbase_env_path]
if not hbase_env_path or not hbase_env_cmd:
print >> sys.stderr, "hbase-env file unknown on platform %s" % os.name
sys.exit(-1)
if hbase_env.has_key('JAVA_HOME'):
java_home = hbase_env['JAVA_HOME']
if java_home:
java = os.path.join(java_home, 'bin', 'java')
else:
java = 'java'
colorSetting = "true"
# disable color setting for windows OS
if os.name == 'nt':
colorSetting = "false"
java_cmd = java + ' $PHOENIX_OPTS ' + \
' -cp "' + phoenix_utils.hbase_conf_dir + os.pathsep + phoenix_utils.phoenix_client_jar + os.pathsep + phoenix_utils.hadoop_common_jar + os.pathsep + phoenix_utils.hadoop_hdfs_jar + \
os.pathsep + phoenix_utils.hadoop_conf + os.pathsep + phoenix_utils.hadoop_classpath + '" -Dlog4j.configuration=file:' + \
os.path.join(phoenix_utils.current_dir, "log4j.properties") + \
" sqlline.SqlLine -d org.apache.phoenix.jdbc.PhoenixDriver \
-u jdbc:phoenix:" + phoenix_utils.shell_quote([zookeeper]) + \
" -n none -p none --color=" + colorSetting + " --fastConnect=false --verbose=true \
--incremental=false --isolation=TRANSACTION_READ_COMMITTED " + sqlfile
childProc = subprocess.Popen(java_cmd, shell=True)
#Wait for child process exit
(output, error) = childProc.communicate()
returncode = childProc.returncode
childProc = None
# Propagate Java return code to this script
if returncode is not None:
sys.exit(returncode)
if len(sys.argv) == 2:
if os.path.isfile(sys.argv[1]):
sqlfile = sys.argv[1]
else:
zookeeper = sys.argv[1]
if len(sys.argv) == 3:
if os.path.isfile(sys.argv[1]):
printUsage()
else:
zookeeper = sys.argv[1]
sqlfile = sys.argv[2]
if sqlfile:
sqlfile = "--run=" + phoenix_utils.shell_quote([sqlfile])
java_home = os.getenv("JAVA_HOME")
# load hbase-env.??? to extract JAVA_HOME, HBASE_PID_DIR, HBASE_LOG_DIR
hbase_env_path = None
hbase_env_cmd = None
if os.name == "posix":
hbase_env_path = os.path.join(hbase_config_path, "hbase-env.sh")
hbase_env_cmd = ["bash", "-c", "source %s && env" % hbase_env_path]
elif os.name == "nt":
hbase_env_path = os.path.join(hbase_config_path, "hbase-env.cmd")
hbase_env_cmd = ["cmd.exe", "/c", "call %s & set" % hbase_env_path]
if not hbase_env_path or not hbase_env_cmd:
print >> sys.stderr, "hbase-env file unknown on platform %s" % os.name
sys.exit(-1)
phoenix_utils.hadoop_hdfs_jar
]
classpath = os.pathsep.join(classpath_components)
# Inline SQL. SQLLine offers no native support.
if options.evaluate:
from tempfile import NamedTemporaryFile
f = NamedTemporaryFile(delete=False)
tempFile = f.name
f.write(options.evaluate)
f.close()
options.run = tempFile
# Special quoting.
if options.run:
options.run = phoenix_utils.shell_quote([options.run])
options.zookeeper = phoenix_utils.shell_quote([options.zookeeper])
# Build the Java command line.
option_hash = dict((x, eval("options.%s" % x)) for x in automatic)
other_options = " ".join(
["--%s=%s" % (x, option_hash[x]) for x in automatic if option_hash[x]])
java_cmd = 'java ' + \
memory_arg + \
'-cp "' + classpath + \
'" -Dlog4j.configuration=file:' + os.path.join(phoenix_utils.current_dir, "log4j.properties") + \
" sqlline.SqlLine -d org.apache.phoenix.jdbc.PhoenixDriver " + \
" -u jdbc:phoenix:" + options.zookeeper + \
" -n none -p none --isolation=TRANSACTION_READ_COMMITTED " + \
other_options
