SQL support in Zeppelin

The following guides explain how to use Apache Zeppelin that enables you to write in SQL:

• provides JDBC Interpreter which allows you can connect any JDBC data sources seamlessly
  • Postgres
  • MySQL
  • MariaDB
  • AWS Redshift
  • Apache Hive
  • Apache Phoenix
  • Apache Drill
  • Apache Tajo
  • and so on
• Spark Interpreter supports SparkSQL
• Python Interpreter supports pandasSQL

• can create query result including UI widgets using Dynamic Form

  %sql 
  select age, count(1) value 
  from bank 
  where age < ${maxAge=30} 
  group by age 
  order by age
  

For the further information about SQL support in Zeppelin, please check

• JDBC Interpreter
• Spark Interpreter
• Python Interpreter
• IgniteSQL Interpreter for Apache Ignite
• Kylin Interpreter for Apache Kylin