DataStax Support Forums » Topic: select error from HIVE

DataStax Support Forums » Topic: select error from HIVE http://www.datastax.com/support-forums/topic/select-error-from-hive Software, Support, and Training for Apache Cassandra en-US Sun, 26 May 2013 09:21:17 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://www.datastax.com/support-forums/search.php Anonymous on "select error from HIVE" http://www.datastax.com/support-forums/topic/select-error-from-hive/page/2#post-1718 Thu, 19 Apr 2012 18:38:27 +0000 Anonymous 1718@http://www.datastax.com/support-forums/ here is output /hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../conf:/home/cassandr/java/jdk1.7.0_03//lib/tools.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/..:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../hadoop-core-1.0.1-dse-20120125.015351-1.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/ant-1.6.5.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/commons-beanutils-1.7.0.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/commons-beanutils-core-1.8.0.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/commons-cli-1.2.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/commons-codec-1.4.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/commons-collections-3.2.1.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/commons-configuration-1.6.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/commons-digester-1.8.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/commons-el-1.0.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/commons-httpclient-3.0.1.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/commons-lang-2.4.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/commons-logging-1.0.4.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/commons-math-2.1.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/commons-net-1.4.1.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/core-3.1.1.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/ftplet-api-1.0.0.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/ftpserver-core-1.0.0.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/ftpserver-deprecated-1.0.0-M2.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/hsqldb-1.8.0.10.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/jackson-core-asl-1.0.1.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/jackson-mapper-asl-1.0.1.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/jasper-compiler-5.5.12.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/jasper-runtime-5.5.12.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/jets3t-0.7.1.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/jetty-6.1.26.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/jetty-util-6.1.26.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/jsp-2.1-6.1.14.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/jsp-api-2.1-6.1.14.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/kfs-0.3.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/mina-core-2.0.0-M5.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/oro-2.0.8.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/servlet-api-2.5-20081211.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/servlet-api-2.5-6.1.14.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/xmlenc-0.52.jar:/hboprod/internet/cassandra/dse-2.0-1/resources/hadoop/bin/../lib/jsp-2.1/*.jar:/hboprod/internet/cassandra/current/resources/cassandra/conf:/hboprod/internet/cassandra/current/resources/cassandra/build/classes/main:/hboprod/internet/cassandra/current/resources/cassandra/build/classes/thrift:/hboprod/internet/cassandra/current/lib:/hboprod/internet/cassandra/current/resources/dse/lib:/hboprod/internet/cassandra/current/resources/dse/conf:/hboprod/internet/cassandra/current/resources/hive/lib:/hboprod/internet/cassandra/current/resources/cassandra/lib/antlr-2.7.7.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/antlr-3.2.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/antlr-runtime-3.2.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/avro-1.4.0-cassandra-1.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/cassandra-all-1.0.8.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/cassandra-clientutil-1.0.8.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/cassandra-cql-1.0.5-bdp1-20111018.182606-1.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/cassandra-thrift-1.0.8.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/commons-cli-1.1.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/commons-codec-1.2.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/commons-lang-2.4.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/commons-logging-1.1.1.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/compress-lzf-0.8.4.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/concurrentlinkedhashmap-lru-1.2.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/guava-r08.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/high-scale-lib-1.1.2.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/httpclient-4.0.1.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/httpcore-4.0.1.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/jackson-core-asl-1.4.0.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/jackson-mapper-asl-1.4.0.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/jamm-0.2.5.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/jetty-6.1.22.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/jetty-util-6.1.22.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/jline-0.9.94.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/jna.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/joda-time-1.6.2.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/json-simple-1.1.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/libthrift-0.6.1.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/log4j-1.2.16.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/mx4j-tools.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/platform.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/servlet-api-2.5-20081211.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/servlet-api-2.5.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/slf4j-api-1.6.1.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/slf4j-api-1.6.4.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/slf4j-simple-1.6.4.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/snakeyaml-1.6.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/snappy-java-1.0.4.1.jar:/hboprod/internet/cassandra/current/resources/cassandra/lib/stringtemplate-3.2.jar:/hboprod/internet/cassandra/current/build/dse*.jar:/hboprod/internet/cassandra/current/lib/dse-2.0-1.jar:/hboprod/internet/cassandra/current/resources/dse/lib/log4j-1.2.16.jar:/hboprod/internet/cassandra/current/resources/dse/lib/slf4j-api-1.6.1.jar:/hboprod/internet/cassandra/current/resources/dse/lib/slf4j-log4j12-1.6.1.jar:/hboprod/internet/cassandra/current/resources/dse/conf:/hboprod/internet/cassandra/current/resources/hive/lib/hive-cassandra-handler-0.8.1-20120308.214130-10.jar:/hboprod/internet/cassandra/current/resources/tomcat/lib/annotations-api-6.0.32.jar:/hboprod/internet/cassandra/current/resources/tomcat/lib/catalina-6.0.32.jar:/hboprod/internet/cassandra/current/resources/tomcat/lib/catalina-ha-6.0.32.jar:/hboprod/internet/cassandra/current/resources/tomcat/lib/coyote-6.0.32.jar:/hboprod/internet/cassandra/current/resources/tomcat/lib/el-api-6.0.29.jar:/hboprod/internet/cassandra/current/resources/tomcat/lib/jasper-6.0.29.jar:/hboprod/internet/cassandra/current/resources/tomcat/lib/jasper-el-6.0.29.jar:/hboprod/internet/cassandra/current/resources/tomcat/lib/jasper-jdt-6.0.29.jar:/hboprod/internet/cassandra/current/resources/tomcat/lib/jsp-api-6.0.29.jar:/hboprod/internet/cassandra/current/resources/tomcat/lib/juli-6.0.32.jar:/hboprod/internet/cassandra/current/resources/tomcat/lib/servlet-api-6.0.29.jar:/hboprod/internet/cassandra/current/resources/tomcat/lib/tribes-6.0.32.jar::/hboprod/internet/cassandra/current/resources/solr/lib/activation-1.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/AlchemyAPIAnnotator-2.3.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/antlr-2.7.2.jar:/hboprod/internet/cassandra/current/resources/solr/lib/asm-3.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/bcmail-jdk15-1.45.jar:/hboprod/internet/cassandra/current/resources/solr/lib/bcprov-jdk15-1.45.jar:/hboprod/internet/cassandra/current/resources/solr/lib/boilerpipe-1.1.0.jar:/hboprod/internet/cassandra/current/resources/solr/lib/commons-beanutils-1.7.0.jar:/hboprod/internet/cassandra/current/resources/solr/lib/commons-chain-1.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/commons-codec-1.4.jar:/hboprod/internet/cassandra/current/resources/solr/lib/commons-collections-3.2.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/commons-compress-1.2.jar:/hboprod/internet/cassandra/current/resources/solr/lib/commons-digester-1.7.jar:/hboprod/internet/cassandra/current/resources/solr/lib/commons-fileupload-1.2.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/commons-httpclient-3.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/commons-io-1.4.jar:/hboprod/internet/cassandra/current/resources/solr/lib/commons-lang-2.4.jar:/hboprod/internet/cassandra/current/resources/solr/lib/commons-logging-1.1.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/commons-validator-1.3.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/dom4j-1.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/fontbox-1.3.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/geronimo-stax-api_1.0_spec-1.0.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/icu4j-4.8.jar:/hboprod/internet/cassandra/current/resources/solr/lib/jakarta-regexp-1.4.jar:/hboprod/internet/cassandra/current/resources/solr/lib/jdom-1.0.jar:/hboprod/internet/cassandra/current/resources/solr/lib/jempbox-1.3.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/jline-0.9.94.jar:/hboprod/internet/cassandra/current/resources/solr/lib/junit-3.8.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/log4j-1.2.15.jar:/hboprod/internet/cassandra/current/resources/solr/lib/lucene-analyzers-common-4.0-20120308.200652-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/lucene-analyzers-phonetic-4.0-20120308.200708-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/lucene-benchmark-4.0-20120308.200747-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/lucene-core-4.0-20120308.200443-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/lucene-grouping-4.0-20120308.200825-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/lucene-highlighter-4.0-20120308.200504-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/lucene-memory-4.0-20120308.200520-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/lucene-misc-4.0-20120308.200529-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/lucene-queries-4.0-20120308.200815-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/lucene-queryparser-4.0-20120308.200849-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/lucene-sandbox-4.0-20120308.200537-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/lucene-spatial-4.0-20120308.200546-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/lucene-suggest-4.0-20120308.200859-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/lucene-xercesImpl-4.0-20120308.200747-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/mail-1.4.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/metadata-extractor-2.4.0-beta-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/OpenCalaisAnnotator-2.3.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/oro-2.0.8.jar:/hboprod/internet/cassandra/current/resources/solr/lib/pdfbox-1.3.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/poi-3.7.jar:/hboprod/internet/cassandra/current/resources/solr/lib/poi-ooxml-3.7.jar:/hboprod/internet/cassandra/current/resources/solr/lib/poi-ooxml-schemas-3.7.jar:/hboprod/internet/cassandra/current/resources/solr/lib/poi-scratchpad-3.7.jar:/hboprod/internet/cassandra/current/resources/solr/lib/rome-0.9.jar:/hboprod/internet/cassandra/current/resources/solr/lib/slf4j-api-1.6.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/solr-cell-4.0-20120308.201132-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/solr-commons-csv-4.0-20120308.200940-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/solr-core-4.0-20120308.200940-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/solr-dataimporthandler-4.0-20120308.201121-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/solr-dataimporthandler-extras-4.0-20120308.201109-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/solr-noggit-4.0-20120308.200940-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/solr-solrj-4.0-20120308.200957-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/solr-uima-4.0-20120308.201151-1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/sslext-1.2-0.jar:/hboprod/internet/cassandra/current/resources/solr/lib/struts-core-1.3.8.jar:/hboprod/internet/cassandra/current/resources/solr/lib/struts-taglib-1.3.8.jar:/hboprod/internet/cassandra/current/resources/solr/lib/struts-tiles-1.3.8.jar:/hboprod/internet/cassandra/current/resources/solr/lib/Tagger-2.3.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/tagsoup-1.2.jar:/hboprod/internet/cassandra/current/resources/solr/lib/tika-core-0.8.jar:/hboprod/internet/cassandra/current/resources/solr/lib/tika-parsers-0.8.jar:/hboprod/internet/cassandra/current/resources/solr/lib/uimaj-core-2.3.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/velocity-1.6.4.jar:/hboprod/internet/cassandra/current/resources/solr/lib/velocity-tools-2.0.jar:/hboprod/internet/cassandra/current/resources/solr/lib/WhitespaceTokenizer-2.3.1.jar:/hboprod/internet/cassandra/current/resources/solr/lib/wstx-asl-3.2.7.jar:/hboprod/internet/cassandra/current/resources/solr/lib/xml-apis-1.0.b2.jar:/hboprod/internet/cassandra/current/resources/solr/lib/xmlbeans-2.3.0.jar:/hboprod/internet/cassandra/current/resources/solr/lib/zookeeper-3.3.3.jar:/hboprod/internet/cassandra/current/resources/solr/conf:/hboprod/internet/cassandra/current/resources/hadoop:/hboprod/internet/cassandra/current/resources/hadoop/conf:/hboprod/internet/cassandra/current/resources/hadoop/hadoop-core-1.0.1-dse-20120125.015351-1.jar:/hboprod/internet/cassandra/current/resources/hadoop/hadoop-examples-1.0.1-dse-20120125.015351-1.jar:/hboprod/internet/cassandra/current/resources/hadoop/hadoop-fairscheduler-0.20.203.1-brisk1.jar:/hboprod/internet/cassandra/current/resources/hadoop/hadoop-streaming-1.0.1-dse-20120125.015351-1.jar:/hboprod/internet/cassandra/current/resources/hadoop/hadoop-test-1.0.1-dse-20120125.015351-1.jar:/hboprod/internet/cassandra/current/resources/hadoop/hadoop-tools-1.0.1-dse-20120125.015351-1.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/ant-1.6.5.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/commons-beanutils-1.7.0.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/commons-beanutils-core-1.8.0.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/commons-cli-1.2.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/commons-codec-1.4.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/commons-collections-3.2.1.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/commons-configuration-1.6.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/commons-digester-1.8.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/commons-el-1.0.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/commons-httpclient-3.0.1.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/commons-lang-2.4.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/commons-logging-1.0.4.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/commons-math-2.1.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/commons-net-1.4.1.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/core-3.1.1.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/ftplet-api-1.0.0.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/ftpserver-core-1.0.0.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/ftpserver-deprecated-1.0.0-M2.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/hsqldb-1.8.0.10.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/jackson-core-asl-1.0.1.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/jackson-mapper-asl-1.0.1.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/jasper-compiler-5.5.12.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/jasper-runtime-5.5.12.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/jets3t-0.7.1.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/jetty-6.1.26.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/jetty-util-6.1.26.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/jsp-2.1-6.1.14.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/jsp-api-2.1-6.1.14.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/kfs-0.3.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/mina-core-2.0.0-M5.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/oro-2.0.8.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/servlet-api-2.5-20081211.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/servlet-api-2.5-6.1.14.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/xmlenc-0.52.jar:/hboprod/internet/cassandra/current/resources/hadoop/lib/jsp-2.1/*.jar tjake on "select error from HIVE" http://www.datastax.com/support-forums/topic/select-error-from-hive/page/2#post-1708 Thu, 19 Apr 2012 13:26:11 +0000 tjake 1708@http://www.datastax.com/support-forums/ There must be something wrong with the classpath. Can you please post the output of "dse hadoop classpath"? Anonymous on "select error from HIVE" http://www.datastax.com/support-forums/topic/select-error-from-hive/page/2#post-1707 Thu, 19 Apr 2012 13:19:55 +0000 Anonymous 1707@http://www.datastax.com/support-forums/ Tjake, Any new update? We upgraded from DSE1.0 to DES 2.0 and still get same errors. [cassandr@nyctweb02d /hboprod/internet/cassandra/current/bin]$ ./dse hive SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/hboprod/internet/cassandra/dse-2.0-1/resources/cassandra/lib/slf4j-simple-1.6.4.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/hboprod/internet/cassandra/dse-2.0-1/resources/dse/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See <a href="http://www.slf4j.org/codes.html#multiple_bindings" rel="nofollow">http://www.slf4j.org/codes.html#multiple_bindings</a> for an explanation. 26 [main] INFO org.apache.cassandra.config.DatabaseDescriptor - Loading settings from file:/hboprod/internet/cassandra/dse-2.0-1/resources/cassandra/conf/cassandra.yaml 919 [main] INFO org.apache.cassandra.config.DatabaseDescriptor - DiskAccessMode 'auto' determined to be mmap, indexAccessMode is mmap 1189 [main] INFO org.apache.cassandra.config.DatabaseDescriptor - Global memtable threshold is enabled at 139MB 2057 [main] INFO com.datastax.bdp.snitch.DseDelegateSnitch - Setting my role to Cassandra 2087 [main] INFO com.datastax.bdp.config.DseConfig - Loading settings from file:/hboprod/internet/cassandra/dse-2.0-1/resources/dse/conf/dse.yaml 2113 [main] INFO com.datastax.bdp.config.DseConfig - Load of settings is done. Logging initialized using configuration in file:/hboprod/internet/cassandra/dse-2.0-1/resources/hive/conf/hive-log4j.properties Hive history file=/tmp/cassandr/hive_job_log_cassandr_201204190848_1061385325.txt hive> show databases; SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/hboprod/internet/cassandra/dse-2.0-1/resources/cassandra/lib/slf4j-simple-1.6.4.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/hboprod/internet/cassandra/dse-2.0-1/resources/dse/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See <a href="http://www.slf4j.org/codes.html#multiple_bindings" rel="nofollow">http://www.slf4j.org/codes.html#multiple_bindings</a> for an explanation. 69 [main] INFO org.apache.cassandra.config.DatabaseDescriptor - Loading settings from file:/hboprod/internet/cassandra/dse-2.0-1/resources/cassandra/conf/cassandra.yaml 339 [main] INFO org.apache.cassandra.config.DatabaseDescriptor - DiskAccessMode 'auto' determined to be mmap, indexAccessMode is mmap 363 [main] INFO org.apache.cassandra.config.DatabaseDescriptor - Global memtable threshold is enabled at 75MB 393 [main] INFO com.datastax.bdp.snitch.DseDelegateSnitch - Setting my role to Cassandra 405 [main] INFO com.datastax.bdp.config.DseConfig - Loading settings from file:/hboprod/internet/cassandra/dse-2.0-1/resources/dse/conf/dse.yaml 425 [main] INFO com.datastax.bdp.config.DseConfig - Load of settings is done. OK default jdtest jdtest1 MyHiveDB OpsCenter Profile Time taken: 4.428 seconds hive> use jdtest1; OK Time taken: 0.013 seconds hive> show tables; 12972 [main] INFO com.datastax.bdp.hadoop.hive.metastore.CassandraHiveMetaStore - in getTables with dbName: jdtest1 and tableNamePattern: .* OK users1 Time taken: 0.292 seconds hive> select * from users1; FAILED: Hive Internal Error: java.lang.RuntimeException(MetaException(message:org.apache.hadoop.hive.serde2.SerDeException SerDe org.apache.hadoop.hive.cassandra.serde.StandardColumnSerDe does not exist)) java.lang.RuntimeException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException SerDe org.apache.hadoop.hive.cassandra.serde.StandardColumnSerDe does not exist) at org.apache.hadoop.hive.ql.metadata.Table.getDeserializerFromMetaStore(Table.java:262) at org.apache.hadoop.hive.ql.metadata.Table.getDeserializer(Table.java:253) at org.apache.hadoop.hive.ql.metadata.Table.getCols(Table.java:490) at org.apache.hadoop.hive.ql.metadata.Table.checkValidity(Table.java:162) at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:942) at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:843) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:908) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:7275) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:243) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:430) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:337) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:889) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:255) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:212) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:403) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:671) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:554) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.apache.hadoop.util.RunJar.main(RunJar.java:156) Caused by: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException SerDe org.apache.hadoop.hive.cassandra.serde.StandardColumnSerDe does not exist) at org.apache.hadoop.hive.metastore.MetaStoreUtils.getDeserializer(MetaStoreUtils.java:211) at org.apache.hadoop.hive.ql.metadata.Table.getDeserializerFromMetaStore(Table.java:260) ... 21 more Anonymous on "select error from HIVE" http://www.datastax.com/support-forums/topic/select-error-from-hive/page/2#post-1614 Thu, 12 Apr 2012 17:45:50 +0000 Anonymous 1614@http://www.datastax.com/support-forums/ from dsetool jobtracker - return [cassandr@nyctweb02d /hboprod/internet/cassandra/dse-1.0.2/resources/dse]$ dsetool jobtracker SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/hboprod/internet/cassandra/dse-1.0.2/resources/cassandra/lib/slf4j-simple-1.6.4.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/hboprod/internet/cassandra/dse-1.0.2/resources/dse/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See <a href="http://www.slf4j.org/codes.html#multiple_bindings" rel="nofollow">http://www.slf4j.org/codes.html#multiple_bindings</a> for an explanation. 5 [main] INFO org.apache.cassandra.config.DatabaseDescriptor - Loading settings from file:/hboprod/internet/cassandra/dse-1.0.2/resources/cassandra/conf/cassandra.yaml 678 [main] INFO org.apache.cassandra.config.DatabaseDescriptor - DiskAccessMode 'auto' determined to be mmap, indexAccessMode is mmap 822 [main] INFO org.apache.cassandra.config.DatabaseDescriptor - Global memtable threshold is enabled at 139MB 10.40.199.206:8012 Anonymous on "select error from HIVE" http://www.datastax.com/support-forums/topic/select-error-from-hive#post-1613 Thu, 12 Apr 2012 17:45:14 +0000 Anonymous 1613@http://www.datastax.com/support-forums/ here are 100 line from system.log INFO [TASK-TRACKER-INIT] 2012-04-12 13:41:43,284 RPC.java (line 321) Server at nyctweb01d.homebox.com/10.40.199.205:8012 not available yet, Zzzzz... INFO [TASK-TRACKER-INIT] 2012-04-12 13:41:45,303 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 0 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:41:46,313 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 1 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:41:47,323 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 2 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:41:48,343 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 3 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:41:49,353 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 4 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:41:50,363 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 5 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:41:51,373 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 6 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:41:52,393 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 7 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:41:53,403 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 8 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:41:54,413 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 9 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:41:54,414 RPC.java (line 321) Server at nyctweb01d.homebox.com/10.40.199.205:8012 not available yet, Zzzzz... INFO [TASK-TRACKER-INIT] 2012-04-12 13:41:56,433 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 0 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:41:57,453 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 1 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:41:58,463 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 2 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:41:59,473 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 3 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:00,483 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 4 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:01,493 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 5 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:02,513 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 6 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:03,523 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 7 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:04,533 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 8 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:05,543 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 9 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:05,544 RPC.java (line 321) Server at nyctweb01d.homebox.com/10.40.199.205:8012 not available yet, Zzzzz... INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:07,573 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 0 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:08,583 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 1 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:09,593 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 2 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:10,613 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 3 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:11,623 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 4 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:12,633 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 5 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:13,643 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 6 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:14,663 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 7 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:15,673 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 8 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:16,683 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 9 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:16,684 RPC.java (line 321) Server at nyctweb01d.homebox.com/10.40.199.205:8012 not available yet, Zzzzz... INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:18,703 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 0 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:19,723 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 1 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:20,732 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 2 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:21,742 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 3 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:22,752 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 4 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:23,762 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 5 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:24,782 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 6 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:25,792 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 7 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:26,802 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 8 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:27,812 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 9 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:27,813 RPC.java (line 321) Server at nyctweb01d.homebox.com/10.40.199.205:8012 not available yet, Zzzzz... INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:29,842 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 0 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:30,852 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 1 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:31,862 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 2 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:32,873 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 3 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:33,882 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 4 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:34,902 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 5 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:35,912 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 6 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:36,922 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 7 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:37,932 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 8 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:38,942 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 9 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:38,943 RPC.java (line 321) Server at nyctweb01d.homebox.com/10.40.199.205:8012 not available yet, Zzzzz... INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:40,972 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 0 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:41,982 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 1 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:42,992 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 2 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:44,002 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 3 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:45,022 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 4 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:46,032 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 5 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:47,042 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 6 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:48,052 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 7 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:49,062 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 8 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:50,082 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 9 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:50,083 RPC.java (line 321) Server at nyctweb01d.homebox.com/10.40.199.205:8012 not available yet, Zzzzz... INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:52,102 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 0 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:53,112 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 1 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:54,122 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 2 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:55,142 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 3 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:56,152 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 4 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:57,162 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 5 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:58,172 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 6 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:42:59,182 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 7 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:00,192 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 8 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:01,202 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 9 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:01,203 RPC.java (line 321) Server at nyctweb01d.homebox.com/10.40.199.205:8012 not available yet, Zzzzz... INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:03,232 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 0 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:04,242 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 1 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:05,252 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 2 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:06,272 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 3 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:07,282 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 4 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:08,292 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 5 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:09,302 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 6 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:10,312 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 7 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:11,332 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 8 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:12,342 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 9 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:12,343 RPC.java (line 321) Server at nyctweb01d.homebox.com/10.40.199.205:8012 not available yet, Zzzzz... INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:14,362 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 0 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:15,372 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 1 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:16,392 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 2 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:17,402 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 3 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:18,412 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 4 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:19,422 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 5 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:20,442 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 6 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:21,452 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 7 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:22,462 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 8 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:23,472 Client.java (line 629) Retrying connect to server: nyctweb01d.homebox.com/10.40.199.205:8012. Already tried 9 time(s). INFO [TASK-TRACKER-INIT] 2012-04-12 13:43:23,473 RPC.java (line 321) Server at nyctweb01d.homebox.com/10.40.199.205:8012 not available yet, Zzzzz... tjake on "select error from HIVE" http://www.datastax.com/support-forums/topic/select-error-from-hive#post-1612 Thu, 12 Apr 2012 17:39:40 +0000 tjake 1612@http://www.datastax.com/support-forums/ Oh I missed above that you are using DSE 1.0.2, I was assuming you were running DSE 2.0 this whole time :) Would it be possible for you to upgrade to DSE 2.0? that is the latest version with the latest hive. tjake on "select error from HIVE" http://www.datastax.com/support-forums/topic/select-error-from-hive#post-1611 Thu, 12 Apr 2012 17:37:09 +0000 tjake 1611@http://www.datastax.com/support-forums/ /var/log/cassandra Anonymous on "select error from HIVE" http://www.datastax.com/support-forums/topic/select-error-from-hive#post-1610 Thu, 12 Apr 2012 17:32:59 +0000 Anonymous 1610@http://www.datastax.com/support-forums/ where to find system.log? tjake on "select error from HIVE" http://www.datastax.com/support-forums/topic/select-error-from-hive#post-1609 Thu, 12 Apr 2012 17:08:41 +0000 tjake 1609@http://www.datastax.com/support-forums/ Can you please post the first 100 lines of the system.log file? I think somehow you have a old version of DSE in your classpath. Are you creating this hive table by hand or using the built in auto schema creation? Anonymous on "select error from HIVE" http://www.datastax.com/support-forums/topic/select-error-from-hive#post-1608 Thu, 12 Apr 2012 17:06:09 +0000 Anonymous 1608@http://www.datastax.com/support-forums/ I dropped the keyspace and recreated keyspace and column family and still got error in HIVE when I did select. hive> select * from users1; FAILED: Hive Internal Error: java.lang.RuntimeException(MetaException(message:org.apache.hadoop.hive.serde2.SerDeException SerDe org.apache.hadoop.hive.cassandra.serde.StandardColumnSerDe does not exist)) java.lang.RuntimeException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException SerDe org.apache.hadoop.hive.cassandra.serde.StandardColumnSerDe does not exist) at org.apache.hadoop.hive.ql.metadata.Table.getDeserializer(Table.java:255) at org.apache.hadoop.hive.ql.metadata.Table.getCols(Table.java:484) at org.apache.hadoop.hive.ql.metadata.Table.checkValidity(Table.java:161) at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:871) at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:772) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:780) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:6594) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:238) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:340) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:736) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:164) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:456) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.apache.hadoop.util.RunJar.main(RunJar.java:156) Caused by: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException SerDe org.apache.hadoop.hive.cassandra.serde.StandardColumnSerDe does not exist) at org.apache.hadoop.hive.metastore.MetaStoreUtils.getDeserializer(MetaStoreUtils.java:207) at org.apache.hadoop.hive.ql.metadata.Table.getDeserializer(Table.java:253) ... 17 more Anonymous on "select error from HIVE" http://www.datastax.com/support-forums/topic/select-error-from-hive#post-1607 Thu, 12 Apr 2012 17:00:39 +0000 Anonymous 1607@http://www.datastax.com/support-forums/ Moderator, we are the current ring setup 10.40.199.205 Cassandra rack1 Up Normal 375.11 MB 25.00% 0 10.40.199.206 Analytics rack1 Up Normal 365.88 MB 25.00% 42535295865117307932921825928971026432 10.40.199.207 Cassandra rack1 Up Normal 372.51 MB 25.00% 85070591730234615865843651857942052864 10.40.199.208 Analytics rack1 Up Normal 365.59 MB 25.00% 127605887595351923798765477786913079296 tjake on "select error from HIVE" http://www.datastax.com/support-forums/topic/select-error-from-hive#post-1606 Thu, 12 Apr 2012 16:58:59 +0000 tjake 1606@http://www.datastax.com/support-forums/ Sorry, I mean't drop it from the cassandra-cli: drop keyspace HiveMetaStore; Anonymous on "select error from HIVE" http://www.datastax.com/support-forums/topic/select-error-from-hive#post-1605 Thu, 12 Apr 2012 16:52:27 +0000 Anonymous 1605@http://www.datastax.com/support-forums/ I tried to drop table and get almost same error when I did select from table. Here are error hive> drop table users1; FAILED: Hive Internal Error: java.lang.RuntimeException(MetaException(message:org.apache.hadoop.hive.serde2.SerDeException SerDe org.apache.hadoop.hive.cassandra.serde.StandardColumnSerDe does not exist)) java.lang.RuntimeException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException SerDe org.apache.hadoop.hive.cassandra.serde.StandardColumnSerDe does not exist) at org.apache.hadoop.hive.ql.metadata.Table.getDeserializer(Table.java:255) at org.apache.hadoop.hive.ql.metadata.Table.getCols(Table.java:484) at org.apache.hadoop.hive.ql.metadata.Table.checkValidity(Table.java:161) at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:871) at org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeDropTable(DDLSemanticAnalyzer.java:648) at org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeInternal(DDLSemanticAnalyzer.java:188) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:238) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:340) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:736) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:164) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:456) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.apache.hadoop.util.RunJar.main(RunJar.java:156) Caused by: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException SerDe org.apache.hadoop.hive.cassandra.serde.StandardColumnSerDe does not exist) at org.apache.hadoop.hive.metastore.MetaStoreUtils.getDeserializer(MetaStoreUtils.java:207) at org.apache.hadoop.hive.ql.metadata.Table.getDeserializer(Table.java:253) ... 16 more tjake on "select error from HIVE" http://www.datastax.com/support-forums/topic/select-error-from-hive#post-1604 Thu, 12 Apr 2012 16:28:32 +0000 tjake 1604@http://www.datastax.com/support-forums/ Ok. well I would suggest if you only have one keyspace and column family to drop the HiveMetaStore keyspace and restart hive to see if that fixes it. Anonymous on "select error from HIVE" http://www.datastax.com/support-forums/topic/select-error-from-hive#post-1603 Thu, 12 Apr 2012 15:58:39 +0000 Anonymous 1603@http://www.datastax.com/support-forums/ Yes, this is a new cluster and new keyspace and column family.