hNfVT26h

1[
2    {
3      "Classification": "hive-site",
4      "Properties": {
5        "javax.jdo.option.ConnectionURL": "jdbc:mysql://${db_url}:3306/hive?createDatabaseIfNotExist=true",
6        "javax.jdo.option.ConnectionDriverName": "org.mariadb.jdbc.Driver",
7        "javax.jdo.option.ConnectionUserName": "${db_username}",
8        "javax.jdo.option.ConnectionPassword": "${db_password}"
9      }
10    }
11  ] 
12     
13CREATE EXTERNAL TABLE IF NOT EXISTS table_name
14(
15key int,
16value int
17)
18LOCATION s3://mybucket/{...}