Hi @Vishal Shah, you also need, in Hive-->Configs: webhcat.proxyuser.knox.groups=* webhcat.proxyuser.knox.hosts=* hive.server2.allow.user.substitution=true Try knox.groups and hosts first with "*" and if it works reduce permissions to for example "users" and your KNOX host FQDN. Full manual here, scroll down to the Hive section. ... View more

Hi @cokorda putra susila, please find here instructions how to try Spark-1.5 on HDP-2.3.2. ... View more

Hi @Suresh Bonam, check this article: HiveWebInterface - Example. However, it's done on HDP-2.3.2, not sure is it going to work in HDP-2.2 but you can try (WebHCat is there, not sure does it support the "hive" command). Edit: It's supported in Hive-0.13+ so should be okay on HDP-2.2. More details here. ... View more

@Roman Boyko Can you try a quick fix described here, setting set hive.server2.enable.doAs=false; before running the query. It's also the mode required for Ranger to manage permissions in Hive. ... View more

@Prakash Punj There are a few mis-configs in your setting hbase.rootdir --hdfs://hdp-m.samitsolutions.com:8020/apps/hbase/data hbase.cluster.distributed - TRUE Metrics service operation mode - embedded hbase.zookeeper.property.clientPort --2181 hbase.zookeeper.quorum --- hdp-m.samitsolutions.com If you run AMS in embedded mode then hbase.cluster.distributed should be false, and hbase.rootdir set to a local directory using the "file://" scheme. If you prefer distributed mode then timeline.metrics.service.operation.mode should be "distributed". In either case, for AMS HBase AMS runs its own instance of ZooKeeper which by default listens on port 61181. It looks like your are trying to use ZooKeeper of the cluster instead. My recommendetion: Switch to the "embedded" mode (unless your cluster has hundreds of nodes), and the default AMS ZK on port 61181. ... View more

It also works with standard Hue-2.6.1 packaged with HDP-2.3.4 (that's the only one I can try; it should also work with Hue coming with 2.3.2 because it's the same version), I tried: SELECT reflect("java.lang.Math","exp",2.0), reflect("java.lang.Math","hypot",3.0,4.0) from t2 limit 1; ... View more

Hi @Neeraj Sabharwal, your view is using referrer_url and page_url from the page_view table which have no access permissions. Not sure is this the reason you get no output from your view. Can you start by setting Hive columns to "*" and then trying to reduce permissions. ... View more