๐Ÿ’ปTech/๐Ÿ˜hadoop

[zeppelin] hive interpreter ์—ฐ๋™ ๋ฐฉ๋ฒ•

_viper_ 2020. 6. 12. 12:44
๋ฐ˜์‘ํ˜•

Zeppelin ์„ค์น˜ ํ›„ hive๋ฅผ ์‚ฌ์šฉํ•˜๋ ค๋ฉด interpreter๋ฅผ ์ถ”๊ฐ€ ํ•ด์ค˜์•ผ ํ•ฉ๋‹ˆ๋‹ค.

์ถ”๊ฐ€ํ•˜์ง€ ์•Š๊ณ  ์‚ฌ์šฉํ•˜๋ฉด ์•„๋ž˜ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•ฉ๋‹ˆ๋‹ค.

Error: Either no interpreter named hive or it is not binded to this note
์›์ธ : hive interpreter ์ƒ์„ฑํ•˜์ง€ ์•Š๊ณ  %hive ์‚ฌ์šฉ์‹œ ๋ฐœ์ƒ

Error : zeppelin Unable to read HiveServer2 configs from ZooKeeper
์›์ธ : hive url ์ฃผ์†Œ๊ฐ€ ์ž˜๋ชป๋ผ์„œ ๋ฐœ์ƒ

 

1. Zeppelin ๋กœ๊ทธ์ธ

 

2. ์˜ค๋ฅธ์ชฝ ์ƒ๋‹จ์— Interpreter ํด๋ฆญ

 

3. Interpreter ํ™”๋ฉด

 

4. ์˜ค๋ฅธ์ชฝ ์ƒ๋‹จ์— create ๋ฒ„ํŠผ์„ ํด๋ฆญํ•˜๊ณ  hive interpreter๋ฅผ ์„ค์ •ํ•ด ์ค๋‹ˆ๋‹ค.

 

5. Interpreter Name : hive / Interpreter group : jdbc

 

6. Properties ์„ค์ •์„ ํ•ด์ค๋‹ˆ๋‹ค

  • ์ ‘์†ํ•  hive ๊ณ„์ •,password,url ์ž…๋ ฅํ•ด ์ค๋‹ˆ๋‹ค

 

PropertyValue

hive.driver org.apache.hive.jdbc.HiveDriver
hive.url jdbc:hive2://localhost:10000
hive.user hiveUser
hive.password hivePassword

 

7. ์„ค์ •์ด ์™„๋ฃŒ๋˜๋ฉด Zeppelin ๋ฉ”์ธ ํ™”๋ฉด์œผ๋กœ ์™€์„œ note ์ƒ์„ฑ ์‹œ hive interpreter๋กœ ์ƒ์„ฑํ•ด์ฃผ๊ณ  ์‚ฌ์šฉํ•˜๋ฉด ๋ฉ๋‹ˆ๋‹ค.