I've filed ZEPPELIN-2447 for this bug. I'll see if I can create PR in github too.
Thanks for the follow-up, Paul > On 22 Apr 2017, at 07:37, moon soo Lee <m...@apache.org> wrote: > > Thanks for reporting problem and share workaround. > It looks like PythonInterpreter uses hardcoded value [1] instead of reading > max_result from interpreter property. > Definitely it looks like a bug. Do you mind file an issue to project JIRA [2]? > > Thanks, > moon > > [1] > https://github.com/apache/zeppelin/blob/v0.7.1/python/src/main/resources/python/zeppelin_python.py#L58 > > <https://github.com/apache/zeppelin/blob/v0.7.1/python/src/main/resources/python/zeppelin_python.py#L58> > [2] https://issues.apache.org/jira/browse/ZEPPELIN > <https://issues.apache.org/jira/browse/ZEPPELIN> > > On Fri, Apr 21, 2017 at 5:10 AM Paul-Armand Verhaegen > <paularmand.verhae...@gmail.com <mailto:paularmand.verhae...@gmail.com>> > wrote: > > running z.__dict in a zeppelin %python paragraph shows that the max_result is > not set (the configuration setting is not applied): > > $ z.__dict__ > > {'javaList': <py4j.java_gateway.JavaClass object at 0x7fe187b776d0>, > 'paramOption': <py4j.java_gateway.JavaClass object at 0x7fe187b77690>, 'z': > JavaObject id=t, 'max_result': 2000, '_displayhook': <function displayhook at > 0x7fe18291baa0>} > > as a workaround, I now issue z.max_result = 2000 to increase the size of the > returned csv and that works fine. > > Thanks, > Paul > >> On 21 Apr 2017, at 13:48, Paul-Armand Verhaegen >> <paularmand.verhae...@gmail.com <mailto:paularmand.verhae...@gmail.com>> >> wrote: >> >> >> Thanks for your reply. Based on your suggestions I've edited >> conf/zeppelin-env.sh adding: >> export ZEPPELIN_SPARK_MAXRESULT=10000 # Max number of Spark SQL result >> to display. 1000 by default. >> export ZEPPELIN_WEBSOCKET_MAX_TEXT_MESSAGE_SIZE=10240000 # Size in >> characters of the maximum text message to be received by websocket. Defaults >> to 1024000 >> >> I've restarted zeppelin, but it still does not show any rows above 1000 >> (neither visualisation nor csv download). >> I also doubled checked the settings by adding "env" in the common.sh to >> ensure that the settings are properly sourced into the shell, and they are. >> >> Paul >> >>> On 20 Apr 2017, at 23:28, So good <33146...@qq.com >>> <mailto:33146...@qq.com>> wrote: >>> >>> The zeppelin configuration file has settings for the maximum number of rows >>> and the maximum size of the file. >>> >>> ------------------ 原始邮件 ------------------ >>> 发件人: "Paul-Armand Verhaegen" <paularmand.verhae...@gmail.com >>> <mailto:paularmand.verhae...@gmail.com>>; >>> 发送时间: 2017年4月21日(星期五) 3:46 >>> 收件人: "users" <users@zeppelin.apache.org <mailto:users@zeppelin.apache.org>>; >>> 主题: Returning more than the default 1000 rows >>> >>> >>> Hi, >>> >>> I have problems making zeppelin 0.7.1 (in %python or %spark.pyspark) to >>> return more than the default 1000 rows (from a pandas dataframe) in a >>> visualisation or csv download. >>> I tried to increase the values of all maxResults settings in >>> interpreter.json, but to no avail (and restarted zeppelin after config >>> change). >>> >>> Can someone point me in the right direction? >>> >>> Thanks, >>> Paul >> >