@ManuN  As this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question.  ... View more

The Phoenix-Hive storage handler as of v4.14.0 (CDH 5.12) seems buggy.  I was able to get the Hive external wrapper table working for simple queries, after tweaking column mapping around upper/lower case gotchas.  However, it fails to work when I tried the "INSERT OVERWRITE DIRECTORY ... SELECT ..." command to export to file: org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undefined column. columnName=<table name>   This is a known problem that no one is apparently looking at: https://issues.apache.org/jira/browse/PHOENIX-4804   ... View more

@Stinger You need to collect the statistics for the table using query 'analyze table', then use describe formatted and describe extended to see the information related to data and number of files. ... View more

@nshelke /tmp/${user.name} in Hive 0.2.0 through 0.8.0 /tmp/hive-${user.name} in Hive 0.8.1 through 0.14.0 /tmp/hive in Hive 0.14.0 and later ... View more

Also, were the links helpful? Any feedback on the documentation is appreciated. ... View more

@pankaj singh WARNING] [WARNING] Some problems were encountered while building the effective model for org.notmysock.tpcds:tpcds-gen:jar:1.0-SNAPSHOT [WARNING] 'build.plugins.plugin.version' for org.apache.maven.plugins:maven-compiler-plugin is missing. @ line 47, column 15 [WARNING] 'build.plugins.plugin.version' for org.apache.maven.plugins:maven-jar-plugin is missing. @ line 54, column 15 [WARNING] [WARNING] It is highly recommended to fix these problems because they threaten the stability of your build. [WARNING] [WARNING] For this reason, future Maven versions might no longer support building such malformed projects. [WARNING] [INFO] [INFO] ------------------------------------------------------------------------ [INFO] Building tpcds-gen 1.0-SNAPSHOT [INFO] ------------------------------------------------------------------------ [WARNING] The POM for org.apache.maven.plugins:maven-resources-plugin:jar:2.5 is invalid, transitive dependencies (if any) will not be available, enable debug logging for more details [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 0.276s [INFO] Finished at: Wed Oct 26 21:19:06 UTC 2016 [INFO] Final Memory: 6M/120M [INFO] ------------------------------------------------------------------------ [ERROR] Failed to parse plugin descriptor for org.apache.maven.plugins:maven-resources-plugin:2.5 (/root/.m2/repository/org/apache/maven/plugins/maven-resources-plugin/2.5/maven-resources-plugin-2.5.jar): error in opening zip file -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/PluginDescriptorParsingException make: *** [target/tpcds-gen-1.0-SNAPSHOT.jar] Error 1 ... View more