How can I get sql results of more than 100 in apache zeppelin?

Question

When I execute this query in apache-zeppelin, I get only 100 results with "Results are limited to 100". message.

%sql SELECT ip FROM log 

So, I added "Limit 10000" to the SQL query, but it only returns 100 results.

 %sql SELECT ip FROM log LIMIT 10000 

So how can I get sql results over 100 in zeppelin?

Answer 1

I decided it myself.

• Click the Interpreter tab in Zeppelin Home.
• Adujust zeppelin.spark.maxResult option in sparking Interpreter.