How can I get sql results over 100 in apache zeppelin?

Question

When I execute this query in apache-zeppelin I get only 100 results with 'Results are limited by 100.' message.

%sql
SELECT ip
FROM log

So I appended 'Limit 10000' in SQL query, but it returns only 100 results again.

%sql
SELECT ip
FROM log
LIMIT 10000

So, How can I get sql results over 100 in zeppelin?

Answer 1

I solved it by myself.

1. Go Interpreter tab in Zeppelin Home.
2. Adujust zeppelin.spark.maxResult option in spark Interpreter.