Re: zeppelin via knox in HDP3 does not work for SQL

2018-08-31 Thread larry mccay
Replacing the service definition files alone isn't quite enough. You have to do the following to make sure that the server picks up the new service defs and redeploys the topology hosting the affected service: 1. change rewrite rules 2. restart gateway so that the gateway is aware of the new servi

Re: zeppelin via knox in HDP3 does not work for SQL

2018-08-31 Thread Lian Jiang
Thanks Sandeep. Could you please clarify the patching process? There is existing rewrite.xml and service.xml under /var/lib/knox/data-3.0.0.0-1634/services/zeppelinui/0.6.0 on the knox host. None of below makes zeppelin sql interpreter work: 1. Put the new rewrite.xml and service.xml into new cre

Re: Impersonate/ProxyUser through Knox?

2018-08-31 Thread Sean Roberts
David – Would you agree that this is a valid feature request? Hortonworks docs suggest replacing HttpFs with Knox, but this is a use case where Knox cannot replace HttpFs which has its own proxyuser functionality. -- Sean Roberts From: David Villarreal Date: Friday, 31 August 2018 at 21:38 To

Re: Impersonate/ProxyUser through Knox?

2018-08-31 Thread David Villarreal
Hi Sean, Proxy/Impersonation is configured on the Hadoop side. And knox user/principal impersonates users. I think the answer to this question is no…. Knox does not have its own proxy impersonation provider. What I know Knox does have is https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.

Re: zeppelin via knox in HDP3 does not work for SQL

2018-08-31 Thread Sandeep Moré
Knox master has patch for this issue https://issues.apache.org/jira/browse/KNOX-1424 You can try applying the patch it should fix the issue. Best, Sandeep On Fri, Aug 31, 2018 at 12:18 PM Lian Jiang wrote: > I am using HDP3.0 (having zeppelin 0.8.0). > > Below queries do not show any result, e

Impersonate/ProxyUser through Knox?

2018-08-31 Thread Sean Roberts
Knox experts – Does Knox provide impersonation/proxyuser functionality like direct WebHDFS connections (hadoop.proxyuser.service-user.users) and HttpFS (httpfs.proxyuser.service-user.users)? For example: * “service-user” authenticates to Knox, then requests to run commands as “normal-user”

zeppelin via knox in HDP3 does not work for SQL

2018-08-31 Thread Lian Jiang
I am using HDP3.0 (having zeppelin 0.8.0). Below queries do not show any result, even though downloading the csv show the data correctly (e.g. if there is no tables, show the header). %livy2.sql show tables %spark2.sql show tables Infrequently I saw the table show a short time and then disappea