zeppelin/docs/quickstart/sql_with_zeppelin.md

layout	title	description	group
page	SQL with Zeppelin		quickstart

{% include JB/setup %}

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