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> 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 >