I am glad the problem is resolved. Both 1) http://nexus-private.hortonworks.com/nexus/content/groups/public/ 2) http://repo.hortonworks.com/content/groups/public/ Will resolve this issue as mentioned in my previous link to refer hortonworks public repo. Please accept the answer ... View more

@Gaurang Shah You are using hortonworks.extrepo (http://repo.hortonworks.com/content/repositories/releases, releases=true, snapshots=true), This repo dont have dependent jars, can you please use http://nexus-private.hortonworks.com/nexus/content/groups/public/ This repo has all the required dependencies eg., 1) org.mortbay.jetty:jetty-util:jar:6.1.ca26.hwx http://nexus-private.hortonworks.com/nexus/content/groups/public/org/mortbay/jetty/jetty-util/6.1.26.hwx/ ... View more

Use hortonworks public repo & try with below maven dependency to compile custom UDF with specific HDP version. <dependency> <groupId>org.apache.hive</groupId> <artifactId>hive-exec</artifactId> <version>1.2.1000.2.6.4.0-91</version> </dependency> Hortonworks maven public repo can be referred from this link ... View more

This can be related to HIVE-13901. Depending on the FS, MSCK & Add partition can be slow. Can you try Setting "hive.fetch.task.conversion=none" ? ... View more

Any fat jar added for UDF ? Can you enable verbose to see which jar is getting loaded ? ... View more

One possible reason i could think is you have hive 1.x serde jar in LLAP classpath. ie., In Hive 1.x, return type of ColumnProjectionUtils.getReadColumnNames is List<String> In Hive 2.x, return type of ColumnProjectionUtils.getReadColumnNames is String[] There is a method return type mismatch which is throwing NoSuchMethodError. ... View more

You can check for the relevant issue in HIVE Jira ... View more

@Hanu V This is related to HIVE-12082. This issue exist in Hive1 1) You can either use Hive2 (Interactive HS2) 2) Workaround using explicitly cast to int. select name, greatest(int(sub1),int(sub2),int(sub3)) from students; 3) Use orc format ... View more

pls try to use below command for creating HiveSampleIn Table CREATE EXTERNAL TABLE HiveSampleIn ( anonid INT, eprofileclass INT, fueltypes STRING, acorn_category INT, acorn_group STRING, acorn_type INT, nuts4 STRING, lacode STRING, nuts1 STRING, gspgroup STRING, ldz STRING, gas_elec STRING, gas_tout STRING ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE LOCATION 'wasb://adfgetstarted@geogstoreacct.blob.core.windows.net/samplein/' tblproperties ("skip.header.line.count"="2"); ... View more

CREATE EXTERNAL TABLE HiveSampleIn ... LOCATION 'wasb://adfgetstarted@geogstoreacct.blob.core.windows.net/samplein/'; -- Getting terminated at here tblproperties ("skip.header.line.count"="2"); -- This might be throwing ParseException ... View more