Thanks Shaofeng, I checked my chrome console and found below error, and I
also found the error in tomcat log
kylin/tomcat/logs/localhost.2016-06-13.log, which should be the root cause:
org.springframework.web.util.NestedServletException: Handler processing
failed; nested exception is java.lang.NoClassDefFoundError:
org/apache/hadoop/hive/ql/session/SessionState
but I can find hive-exec-1.2.1.jar in the result of find-hive-dependency.sh
and the process, is there any other configuration I missed?
2016-06-12 22:05 GMT+08:00 ShaoFeng Shi <[email protected]>:
> It seems the request wasn't received by the server at all; Most likely be
> a client side or network error; If you're using firefox or chrome, please
> press F12 to open the console, and then check whether there is any JS or
> HTTP error on the console.
>
> 2016-06-12 17:08 GMT+08:00 蔡冉 <[email protected]>:
>
>> I got error 'Oops... Failed to take action.' when trying to load hive
>> table in Kylin web ui, and no obvious error could be found in the log file,
>> anyone have met the problem before?
>>
>> My environment:
>>
>> Version:
>> hadoop: 2.7.1
>> hive: 1.2.1
>> hbase: 1.1.2
>> kylin: 1.5.2
>>
>> We have total 20 physical servers in hadoop cluster, including 2 masters(
>> for HA) and 18 slaves.
>>
>> Kylin installed in a docker container (for facilitating the test), and in
>> this docker container, whole of hadoop, hive and hbase installation dir
>> were copied from hadoop cluster servers. Commands like 'hadoop fs -ls',
>> 'hive', 'hbase shell' can run and response successfully. Hive use a remote
>> mysql server for metastore, the configuration was properly specified in
>> hive-site.xml.
>>
>> Attachment were the log files, any help would be appreciated.
>>
>>
>>
>>
>
>
> --
> Best regards,
>
> Shaofeng Shi
>
>
[root@d7d6c46b8f9d bin]# ./find-hive-dependency.sh
Logging initialized using configuration in
jar:file:/home/y/usr/local/apache-hive-1.2.1-bin/lib/hive-common-1.2.1.jar!/hive-log4j.properties
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further
details.
HCAT_HOME is set to: /home/y/usr/local/hive/hcatalog/share/hcatalog, use it to
find hcatalog path:
hive dependency:
/home/y/usr/local/hive/conf:/home/y/usr/local/hive/lib/paranamer-2.3.jar:/home/y/usr/local/hive/lib/commons-httpclient-3.0.1.jar:/home/y/usr/local/hive/lib/httpclient-4.4.jar:/home/y/usr/local/hive/lib/mysql-connector-java-5.1.36-bin.jar:/home/y/usr/local/hive/lib/libfb303-0.9.2.jar:/home/y/usr/local/hive/lib/mail-1.4.1.jar:/home/y/usr/local/hive/lib/hive-hbase-handler-1.2.1.jar:/home/y/usr/local/hive/lib/hive-hwi-1.2.1.jar:/home/y/usr/local/hive/lib/commons-beanutils-core-1.8.0.jar:/home/y/usr/local/hive/lib/curator-framework-2.6.0.jar:/home/y/usr/local/hive/lib/guava-14.0.1.jar:/home/y/usr/local/hive/lib/ST4-4.0.4.jar:/home/y/usr/local/hive/lib/commons-cli-1.2.jar:/home/y/usr/local/hive/lib/pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar:/home/y/usr/local/hive/lib/ant-1.9.1.jar:/home/y/usr/local/hive/lib/hive-shims-0.23-1.2.1.jar:/home/y/usr/local/hive/lib/eigenbase-properties-1.1.5.jar:/home/y/usr/local/hive/lib/tempus-fugit-1.1.jar:/home/y/usr/local/hive/lib/jsr305-3.0.0.jar:/home/y/usr/local/hive/lib/jdo-api-3.0.1.jar:/home/y/usr/local/hive/lib/plexus-utils-1.5.6.jar:/home/y/usr/local/hive/lib/curator-client-2.6.0.jar:/home/y/usr/local/hive/lib/asm-commons-3.1.jar:/home/y/usr/local/hive/lib/activation-1.1.jar:/home/y/usr/local/hive/lib/maven-scm-provider-svn-commons-1.4.jar:/home/y/usr/local/hive/lib/super-csv-2.2.0.jar:/home/y/usr/local/hive/lib/datanucleus-core-3.2.10.jar:/home/y/usr/local/hive/lib/commons-vfs2-2.0.jar:/home/y/usr/local/hive/lib/jetty-all-7.6.0.v20120127.jar:/home/y/usr/local/hive/lib/ant-launcher-1.9.1.jar:/home/y/usr/local/hive/lib/commons-configuration-1.6.jar:/home/y/usr/local/hive/lib/hive-common-1.2.1.jar:/home/y/usr/local/hive/lib/accumulo-trace-1.6.0.jar:/home/y/usr/local/hive/lib/hive-cli-1.2.1.jar:/home/y/usr/local/hive/lib/jcommander-1.32.jar:/home/y/usr/local/hive/lib/groovy-all-2.1.6.jar:/home/y/usr/local/hive/lib/libthrift-0.9.2.jar:/home/y/usr/local/hive/lib/hive-shims-sc
heduler-1.2.1.jar:/home/y/usr/local/hive/lib/curator-recipes-2.6.0.jar:/home/y/usr/local/hive/lib/accumulo-fate-1.6.0.jar:/home/y/usr/local/hive/lib/commons-dbcp-1.4.jar:/home/y/usr/local/hive/lib/geronimo-annotation_1.0_spec-1.1.1.jar:/home/y/usr/local/hive/lib/avro-1.7.5.jar:/home/y/usr/local/hive/lib/hive-jdbc-1.2.1-standalone.jar:/home/y/usr/local/hive/lib/hive-exec-1.2.1.jar:/home/y/usr/local/hive/lib/maven-scm-api-1.4.jar:/home/y/usr/local/hive/lib/hamcrest-core-1.1.jar:/home/y/usr/local/hive/lib/velocity-1.5.jar:/home/y/usr/local/hive/lib/commons-collections-3.2.1.jar:/home/y/usr/local/hive/lib/geronimo-jta_1.1_spec-1.1.1.jar:/home/y/usr/local/hive/lib/zookeeper-3.4.6.jar:/home/y/usr/local/hive/lib/opencsv-2.3.jar:/home/y/usr/local/hive/lib/datanucleus-rdbms-3.2.9.jar:/home/y/usr/local/hive/lib/commons-logging-1.1.3.jar:/home/y/usr/local/hive/lib/servlet-api-2.5.jar:/home/y/usr/local/hive/lib/commons-codec-1.4.jar:/home/y/usr/local/hive/lib/netty-3.7.0.Final.jar:/home/y/usr/local/hive/lib/jetty-all-server-7.6.0.v20120127.jar:/home/y/usr/local/hive/lib/joda-time-2.5.jar:/home/y/usr/local/hive/lib/snappy-java-1.0.5.jar:/home/y/usr/local/hive/lib/json-20090211.jar:/home/y/usr/local/hive/lib/apache-log4j-extras-1.2.17.jar:/home/y/usr/local/hive/lib/janino-2.7.6.jar:/home/y/usr/local/hive/lib/commons-compiler-2.7.6.jar:/home/y/usr/local/hive/lib/geronimo-jaspic_1.0_spec-1.0.jar:/home/y/usr/local/hive/lib/antlr-2.7.7.jar:/home/y/usr/local/hive/lib/httpcore-4.4.jar:/home/y/usr/local/hive/lib/hive-ant-1.2.1.jar:/home/y/usr/local/hive/lib/hive-metastore-1.2.1.jar:/home/y/usr/local/hive/lib/derby-10.10.2.0.jar:/home/y/usr/local/hive/lib/accumulo-core-1.6.0.jar:/home/y/usr/local/hive/lib/jline-2.12.jar:/home/y/usr/local/hive/lib/hive-beeline-1.2.1.jar:/home/y/usr/local/hive/lib/oro-2.0.8.jar:/home/y/usr/local/hive/lib/log4j-1.2.16.jar:/home/y/usr/local/hive/lib/jta-1.1.jar:/home/y/usr/local/hive/lib/hive-shims-common-1.2.1.jar:/home/y/usr/local/hive/lib/hive-serde-1.2.1.jar:/home/y/usr/local/hive/lib/datanucleus-api-jdo-3.2.6.jar:/home/y/usr/local/hive/lib/accumulo-start-1.6.0.jar:/home/y/usr/local/hive/lib/maven-scm-provider-svnexe-1.4.jar:/home/y/usr/local/hive/lib/commons-pool-1.5.4.jar:/home/y/usr/local/hive/lib/parquet-hadoop-bundle-1.6.0.jar:/home/y/usr/local/hive/lib/commons-beanutils-1.7.0.jar:/home/y/usr/local/hive/lib/ivy-2.4.0.jar:/home/y/usr/local/hive/lib/commons-lang-2.6.jar:/home/y/usr/local/hive/lib/junit-4.11.jar:/home/y/usr/local/hive/lib/bonecp-0.8.0.RELEASE.jar:/home/y/usr/local/hive/lib/xz-1.0.jar:/home/y/usr/local/hive/lib/regexp-1.3.jar:/home/y/usr/local/hive/lib/commons-compress-1.4.1.jar:/home/y/usr/local/hive/lib/antlr-runtime-3.4.jar:/home/y/usr/local/hive/lib/hive-shims-1.2.1.jar:/home/y/usr/local/hive/lib/hive-jdbc-1.2.1.jar:/home/y/usr/local/hive/lib/stringtemplate-3.2.1.jar:/home/y/usr/local/hive/lib/commons-digester-1.8.jar:/home/y/usr/local/hive/lib/hive-testutils-1.2.1.jar:/home/y/usr/local/hive/lib/hive-service-1.2.1.jar:/home/y/usr/local/hive/lib/hive-contrib-1.2.1.jar:/home/y/usr/local/hive/lib/stax-api-1.0.1.jar:/home/y/usr/local/hive/lib/commons-io-2.4.jar:/home/y/usr/local/hive/lib/asm-tree-3.1.jar:/home/y/usr/local/hive/lib/jpam-1.1.jar:/home/y/usr/local/hive/lib/hive-shims-0.20S-1.2.1.jar:/home/y/usr/local/hive/lib/commons-math-2.1.jar:/home/y/usr/local/hive/lib/hive-accumulo-handler-1.2.1.jar:/home/y/usr/local/hive/hcatalog/share/hcatalog/hive-hcatalog-core-1.2.1.jar
[root@d7d6c46b8f9d bin]#
[root@d7d6c46b8f9d bin]# ps -ef | grep java
root 8968 1 1 07:16 ? 00:00:45
/usr/lib/jvm/java-openjdk/bin/java -Dproc_-Xms1024M -XX:OnOutOfMemoryError=kill
-9 %p -XX:+UseConcMarkSweepGC -Dhbase.log.dir=/home/y/var/log/hbase
-Dhbase.log.file=hbase.log -Dhbase.home.dir=/home/y/usr/local/hbase
-Dhbase.id.str= -Dhbase.root.logger=INFO,RFA
-Djava.library.path=/home/y/usr/local/hadoop-2.7.1/lib/native
-Dhbase.security.logger=INFO,NullAppender -Xms1024M -Xmx4096M
-XX:MaxPermSize=128M -verbose:gc -XX:+PrintGCDetails -XX:+PrintGCDateStamps
-Xloggc:/home/y/usr/local/kylin/bin/..//logs/kylin.gc.6405
-XX:+UseGCLogFileRotation -XX:NumberOfGCLogFiles=10 -XX:GCLogFileSize=64M
-Djava.util.logging.config.file=/home/y/usr/local/kylin/bin/../tomcat/conf/logging.properties
-Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
-Dorg.apache.tomcat.util.buf.UDecoder.ALLOW_ENCODED_SLASH=true
-Dorg.apache.catalina.connector.CoyoteAdapter.ALLOW_BACKSLASH=true
-Djava.endorsed.dirs=/home/y/usr/local/kylin/bin/../tomcat/endorsed
-Dcatalina.base=/home/y/usr/local/kylin/bin/../tomcat
-Dcatalina.home=/home/y/usr/local/kylin/bin/../tomcat
-Djava.io.tmpdir=/home/y/usr/local/kylin/bin/../tomcat/temp
-Dkylin.hive.dependency=/home/y/usr/local/hive/conf:/home/y/usr/local/hive/lib/paranamer-2.3.jar:/home/y/usr/local/hive/lib/commons-httpclient-3.0.1.jar:/home/y/usr/local/hive/lib/httpclient-4.4.jar:/home/y/usr/local/hive/lib/mysql-connector-java-5.1.36-bin.jar:/home/y/usr/local/hive/lib/libfb303-0.9.2.jar:/home/y/usr/local/hive/lib/mail-1.4.1.jar:/home/y/usr/local/hive/lib/hive-hbase-handler-1.2.1.jar:/home/y/usr/local/hive/lib/hive-hwi-1.2.1.jar:/home/y/usr/local/hive/lib/commons-beanutils-core-1.8.0.jar:/home/y/usr/local/hive/lib/curator-framework-2.6.0.jar:/home/y/usr/local/hive/lib/guava-14.0.1.jar:/home/y/usr/local/hive/lib/ST4-4.0.4.jar:/home/y/usr/local/hive/lib/commons-cli-1.2.jar:/home/y/usr/local/hive/lib/pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar:/home/y/usr/local/hive/lib/ant-1.9.1.jar:/home/y/usr/local/hive/lib/hive-shims-0.23-1.2.1.jar:/home/y/usr/local/hive/lib/eigenbase-properties-1.1.5.jar:/home/y/usr/local/hive/lib/tempus-fugit-1.1.jar:/home/y/usr/local/hive/lib/jsr305-3.0.0.jar:/home/y/usr/local/hive/lib/jdo-api-3.0.1.jar:/home/y/usr/local/hive/lib/plexus-utils-1.5.6.jar:/home/y/usr/local/hive/lib/curator-client-2.6.0.jar:/home/y/usr/local/hive/lib/asm-commons-3.1.jar:/home/y/usr/local/hive/lib/activation-1.1.jar:/home/y/usr/local/hive/lib/maven-scm-provider-svn-commons-1.4.jar:/home/y/usr/local/hive/lib/super-csv-2.2.0.jar:/home/y/usr/local/hive/lib/datanucleus-core-3.2.10.jar:/home/y/usr/local/hive/lib/commons-vfs2-2.0.jar:/home/y/usr/local/hive/lib/jetty-all-7.6.0.v20120127.jar:/home/y/usr/local/hive/lib/ant-launcher-1.9.1.jar:/home/y/usr/local/hive/lib/commons-configuration-1.6.jar:/home/y/usr/local/hive/lib/hive-common-1.2.1.jar:/home/y/usr/local/hive/lib/accumulo-trace-1.6.0.jar:/home/y/usr/local/hive/lib/hive-cli-1.2.1.jar:/home/y/usr/local/hive/lib/jcommander-1.32.jar:/home/y/usr/local/hive/lib/groovy-all-2.1.6.jar:/home/y/usr/local/hive/lib/libthrift-0.9.2.jar:/home/y/usr/local/hive/lib/hive-shims-scheduler-1.2.1.jar:/home/y/usr/local/hive/lib/curator-recipes-2.6.0.jar:/home/y/usr/local/hive/lib/accumulo-fate-1.6.0.jar:/home/y/usr/local/hive/lib/commons-dbcp-1.4.jar:/home/y/usr/local/hive/lib/geronimo-annotation_1.0_spec-1.1.1.jar:/home/y/usr/local/hive/lib/avro-1.7.5.jar:/home/y/usr/local/hive/lib/hive-jdbc-1.2.1-standalone.jar:/home/y/usr/local/hive/lib/hive-exec-1.2.1.jar:/home/y/usr/local/hive/lib/maven-scm-api-1.4.jar:/home/y/usr/local/hive/lib/hamcrest-core-1.1.jar:/home/y/usr/local/hive/lib/velocity-1.5.jar:/home/y/usr/local/hive/lib/commons-collections-3.2.1.jar:/home/y/usr/local/hive/lib/geronimo-jta_1.1_spec-1.1.1.jar:/home/y/usr/local/hive/lib/zookeeper-3.4.6.jar:/home/y/usr/local/hive/lib/opencsv-2.3.jar:/home/y/usr/local/hive/lib/datanucleus-rdbms-3.2.9.jar:/home/y/usr/local/hive/lib/commons-logging-1.1.3.jar:/home/y/usr/local/hive/lib/servlet-api-2.5.jar:/home/y/usr/local/hive/lib/commons-codec-1.4.jar:/home/y/usr/local/hive/lib/netty-3.7.0.Final.jar:/home/y/usr/local/hive/lib/
root 10485 6316 0 08:22 ? 00:00:00 grep java
[root@d7d6c46b8f9d bin]#
