Do you see any error in "logs/zeppelin-interpreter-md-*" files ? Thanks, moon
On Fri, Jun 3, 2016 at 2:18 PM Brian Weissler <bweiss...@aginity.com> wrote: > > > > > Hi all, I’m trying to use the %sh interpreter to execute SQL via the Hive > CLI. Just to answer the question, “why wouldn’t you just use the %hive > interpreter” … I want to execute Hive on a SQL file rather than typing my > SQL into the interface. If there’s a way to do this using the %hive > interpreter, please advise. Otherwise, here’s the trouble I am having. > > > > I am consistently receiving the error “Process exited with an error: 134 > (Exit value: 134)”. I know the Hive CLI is deprecated, so I show here that > the same problem exists trying to run Beeline. > > > > [image: image001.png] > > > > I’ve proven that I can run these commands successfully from command line > as the zeppelin user. > > > > [zeppelin@sandbox ~]$ whoami > > zeppelin > > ---------------- > > > > [zeppelin@sandbox ~]$ hive --version > > SLF4J: Class path contains multiple SLF4J bindings. > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/spark/lib/spark-assembly-1.4.1.2.3.2.0-2950-hadoop2.7.1.2.3.2.0-2950.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.slf4j.impl.Log4jLoggerFactory] > > WARNING: Use "yarn jar" to launch YARN applications. > > SLF4J: Class path contains multiple SLF4J bindings. > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/spark/lib/spark-assembly-1.4.1.2.3.2.0-2950-hadoop2.7.1.2.3.2.0-2950.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.slf4j.impl.Log4jLoggerFactory] > > Hive 1.2.1.2.3.2.0-2950 > > Subversion > git://c66-slave-20176e25-6/grid/0/jenkins/workspace/HDP-2.3-maint-centos6/bigtop/build/hive/rpm/BUILD/hive-1.2.1.2.3.2.0 > -r c67988138ca472655a6978f50c7423525b71dc27 > > Compiled by jenkins on Wed Sep 30 19:07:31 UTC 2015 > > From source with checksum 6c57f9c021f6f833a9ef075f629c8b03 > > > > ---------------- > > > > [zeppelin@sandbox ~]$ hive -e "show databases" > > SLF4J: Class path contains multiple SLF4J bindings. > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/spark/lib/spark-assembly-1.4.1.2.3.2.0-2950-hadoop2.7.1.2.3.2.0-2950.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.slf4j.impl.Log4jLoggerFactory] > > WARNING: Use "yarn jar" to launch YARN applications. > > SLF4J: Class path contains multiple SLF4J bindings. > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/spark/lib/spark-assembly-1.4.1.2.3.2.0-2950-hadoop2.7.1.2.3.2.0-2950.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.slf4j.impl.Log4jLoggerFactory] > > > > Logging initialized using configuration in > file:/etc/hive/2.3.2.0-2950/0/hive-log4j.properties > > OK > > amp_demo_base > > amp_demo_mart > > bweissler_base > > bweissler_land > > cdh_recon_shared > > default > > single_view_base > > xademo > > Time taken: 2.041 seconds, Fetched: 8 row(s) > > > > ---------------- > > > > [zeppelin@sandbox ~]$ beeline --version > > SLF4J: Class path contains multiple SLF4J bindings. > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/spark/lib/spark-assembly-1.4.1.2.3.2.0-2950-hadoop2.7.1.2.3.2.0-2950.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/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.slf4j.impl.Log4jLoggerFactory] > > WARNING: Use "yarn jar" to launch YARN applications. > > SLF4J: Class path contains multiple SLF4J bindings. > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/spark/lib/spark-assembly-1.4.1.2.3.2.0-2950-hadoop2.7.1.2.3.2.0-2950.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/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.slf4j.impl.Log4jLoggerFactory] > > Hive 1.2.1.2.3.2.0-2950 > > Subversion > git://c66-slave-20176e25-6/grid/0/jenkins/workspace/HDP-2.3-maint-centos6/bigtop/build/hive/rpm/BUILD/hive-1.2.1.2.3.2.0 > -r c67988138ca472655a6978f50c7423525b71dc27 > > Compiled by jenkins on Wed Sep 30 19:07:31 UTC 2015 > > From source with checksum 6c57f9c021f6f833a9ef075f629c8b03 > > > > ---------------- > > > > [zeppelin@sandbox ~]$ beeline -u jdbc:hive2://localhost:10000 -e "show > databases" > > SLF4J: Class path contains multiple SLF4J bindings. > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/spark/lib/spark-assembly-1.4.1.2.3.2.0-2950-hadoop2.7.1.2.3.2.0-2950.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/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.slf4j.impl.Log4jLoggerFactory] > > WARNING: Use "yarn jar" to launch YARN applications. > > SLF4J: Class path contains multiple SLF4J bindings. > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/spark/lib/spark-assembly-1.4.1.2.3.2.0-2950-hadoop2.7.1.2.3.2.0-2950.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/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.slf4j.impl.Log4jLoggerFactory] > > Connecting to jdbc:hive2://localhost:10000 > > Connected to: Apache Hive (version 1.2.1.2.3.2.0-2950) > > Driver: Hive JDBC (version 1.2.1.2.3.2.0-2950) > > Transaction isolation: TRANSACTION_REPEATABLE_READ > > +-------------------+--+ > > | database_name | > > +-------------------+--+ > > | amp_demo_base | > > | amp_demo_mart | > > | bweissler_base | > > | bweissler_land | > > | cdh_recon_shared | > > | default | > > | single_view_base | > > | xademo | > > +-------------------+--+ > > 8 rows selected (0.125 seconds) > > Beeline version 1.2.1.2.3.2.0-2950 by Apache Hive > > Closing: 0: jdbc:hive2://localhost:10000 > > > > > > > > Any ideas would be appreciated. > > > > - brian > > >
