https://community.cloudera.com/t5/Archives-of-Support-Questions/sql-interpreter-shows-empty-result-in-zeppelin-via-knox-in/m-p/178058#M82995 <P>It is a knox bug <A href="https://issues.apache.org/jira/browse/KNOX-1424">https://issues.apache.org/jira/browse/KNOX-1424</A>. After patching the fix, SQL interpreter show results.</P> Wed, 05 Sep 2018 04:07:18 GMT jiangok2006 2018-09-05T04:07:18Z https://community.cloudera.com/t5/Archives-of-Support-Questions/sql-interpreter-shows-empty-result-in-zeppelin-via-knox-in/m-p/178057#M82994 <P>I am using HDP3.0 (having zeppelin 0.8.0).<BR /><BR />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).<BR /><BR />%livy2.sqlshow tables<BR /><BR />%spark2.sql<BR />show tables<BR /><BR />Infrequently I saw the table show a short time and then disappear. I guess it is html rendering issue. <BR /><BR />This issue does not happen when I ssh to the zeppelin host and use zeppelin via port forwarding. It happens when I use zeppelin via knox.</P><DIV>Any idea? Any setting is related to this? Sql interpreters worked fine in HDP2.6 using zeppelin 0.7.3.<BR /><BR /><DIV>javascript error:<BR /><DIV><DIV>Error: [ngRepeat:iidexp] '_item_' in '_item_ in _collection_' should be an identifier or '(_key_, _value_)' expression, but got '/gateway/ui/zeppelin/app'. <A href="http://errors.angularjs.org/1.5.7/ngRepeat/iidexp?p0=%2Fgateway%2Fui%2Fzeppelin%2Fapp">http://errors.angularjs.org/1.5.7/ngRepeat/iidexp?p0=%2Fgateway%2Fui%2Fzeppelin%2Fapp</A> b/&lt;@<A href="https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:36:376">https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:36:376</A> Kg&lt;/&lt;.compile@<A href="https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:40:30580">https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:40:30580</A> Z@<A href="https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:37:4755">https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:37:4755</A> S@<A href="https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:36:30480">https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:36:30480</A> S@<A href="https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:36:30611">https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:36:30611</A> S@<A href="https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:36:30611">https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:36:30611</A> N@<A href="https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:36:29413">https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:36:29413</A> X/&lt;@<A href="https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:37:440">https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:37:440</A> d@<A href="https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:36:30833">https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:36:30833</A> m@<A href="https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:37:909">https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:37:909</A> mg&lt;/&lt;.link/&lt;@<A href="https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:40:17582">https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:40:17582</A> xc/this.$get&lt;/o.prototype.$digest@<A href="https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:38:10966">https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:38:10966</A> a/n.prototype.safeDigest@<A href="https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:76:1460">https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:76:1460</A> b@<A href="https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:76:3748">https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:76:3748</A> a/n.prototype._onMessageHandler@<A href="https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:76:3960">https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:76:3960</A> R/&lt;@<A href="https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:36:5633">https://mydomain.com/gateway/ui/zeppelin/scripts/vendor.49d751b0c72342f6.js:36:5633</A> " &lt;!-- ngRepeat: /gateway/ui/zeppelin/app in apps --&gt;<BR /><BR /><BR /><P>Appreciate any clue.</P></DIV></DIV></DIV></DIV> Fri, 31 Aug 2018 23:40:53 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/sql-interpreter-shows-empty-result-in-zeppelin-via-knox-in/m-p/178057#M82994 jiangok2006 2018-08-31T23:40:53Z https://community.cloudera.com/t5/Archives-of-Support-Questions/sql-interpreter-shows-empty-result-in-zeppelin-via-knox-in/m-p/178058#M82995 <P>It is a knox bug <A href="https://issues.apache.org/jira/browse/KNOX-1424">https://issues.apache.org/jira/browse/KNOX-1424</A>. After patching the fix, SQL interpreter show results.</P> Wed, 05 Sep 2018 04:07:18 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/sql-interpreter-shows-empty-result-in-zeppelin-via-knox-in/m-p/178058#M82995 jiangok2006 2018-09-05T04:07:18Z