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
  • Presto/Trino
  • Impala
  • Apache Kyuubi
  • Apache Phoenix
  • Apache Drill
  • Apache Tajo
  • and so on
• Spark Interpreter supports SparkSQL
• Flink Interpreter supports Flink SQL
• 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
• Flink Interpreter
• Python Interpreter