Dear Zeppelin user community, One of our users requested an option to limit the number of rows shown in Zeppelin UI, while being able to export all the data (with higher limitation). We are using a JDBC interpreter that connects to a Hive cluster.
>From reading the documentation Zeppelin supports it via these two parameters: [image: Screenshot from 2019-09-24 09-56-52.png] [image: Screenshot from 2019-09-24 09-56-33.png] * common.max_count* - limits the total number of records * common.max_result* - limits the results shown in the UI It also looks like the UI support exporting all data or only visible data too: [image: Screenshot from 2019-09-24 10-01-20.png] common.max_count works well and controls how many rows are returned, but common.max_result doesn't seem to change anything. We are using Zeppelin 0.8.0, I did not find any open bug on this issue, does this feature work? and if not will it work in 0.8.1\2 or 0.9.0 ? WIll appreciate any leads on this matter, thank you! *Some technical data:* *interpreter.json contains this option:* "common.max_result": { "name": "common.max_result", "value": "5", "type": "number" }, *Logs show the parameter does pass to the JDBC drive:* DEBUG [2019-09-23 09:17:25,581] ({pool-2-thread-2} JDBCInterpreter.java[open]:207) - JDBC PropretiesMap: {default={url=jdbc:hive2://xxxxxx:10000, completer.schemaFilters=, user=zeppelin, statementPrecode=, splitQueries=false, password=, driver=org.apache.hive.jdbc.HiveDriver, completer.ttlInSeconds=120, precode=}, common={max_result=5, max_count=1000}} -- Eyal Hashai <http://www.kenshoo.com/>*Database Administrator - Big Data Team | Kenshoo* m: +972 (50) 404-0473 *o*: +972 (3) 746-6500 x552 w: www.kenshoo.com l: linkedin.com/eyal-hashai-2667586a <https://www.linkedin.com/in/eyal-hashai-2667586a/>Named #1 in Search & Social by Internet Retailer 2015 - 2019 * <eyal.has...@kenshoo.com>* <http://kenshoo.com/> -- This e-mail, as well as any attached document, may contain material which is confidential and privileged and may include trademark, copyright and other intellectual property rights that are proprietary to Kenshoo Ltd, its subsidiaries or affiliates ("Kenshoo"). This e-mail and its attachments may be read, copied and used only by the addressee for the purpose(s) for which it was disclosed herein. If you have received it in error, please destroy the message and any attachment, and contact us immediately. If you are not the intended recipient, be aware that any review, reliance, disclosure, copying, distribution or use of the contents of this message without Kenshoo's express permission is strictly prohibited.