Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "display_name": "PySpark ",
- "language": "python3",
- "argv": [
- "/usr/bin/python3",
- "-m",
- "IPython.kernel",
- "-f",
- "{connection_file}"
- ],
- "env": {
- "SPARK_HOME": "<mypath>/spark-1.6.0",
- "PYTHONSTARTUP": "<mypath>/spark-1.6.0/python/pyspark/shell.py",
- "PYSPARK_SUBMIT_ARGS": "--master spark://<mymaster>:7077 --conf spark.executor.memory=2G pyspark-shell --driver-class-path /opt/vertica/java/lib/vertica-jdbc.jar"
- }
- }
- # download postgres jar
- wget https://jdbc.postgresql.org/download/postgresql-42.1.4.jar
- # install postgres on your machine
- pip install postgres
- # add user, pass and db to postgres
- psql -d postgres -c "create user hive"
- psql -d postgres -c "alter user hive with password 'pass'"
- psql -d postgres -c "create database hive_metastore"
- psql -d postgres -c "grant all privileges on database hive_metastore to hive"
- <configuration>
- <property>
- <name>javax.jdo.option.ConnectionURL</name>
- <value>jdbc:postgresql://localhost:5432/hive_metastore</value>
- </property>
- <property>
- <name>javax.jdo.option.ConnectionDriverName</name>
- <value>org.postgresql.Driver</value>
- </property>
- <property>
- <name>javax.jdo.option.ConnectionUserName</name>
- <value>hive</value>
- </property>
- <property>
- <name>javax.jdo.option.ConnectionPassword</name>
- <value>pass</value>
- </property>
- </configuration>
Add Comment
Please, Sign In to add comment