๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

๐Ÿ’ปTech/๐Ÿ˜hadoop27

Cloudera Streams Messaging Manager Installation ๐Ÿšซ ERROR org.flywaydb.core.api.FlywayException: Unable to instantiate JDBC driver class not found exception com.mysql.cj.jdbc.driver ๐Ÿ’ก SOLVED https://docs.cloudera.com/cdp-private-cloud-base/latest/installation/topics/csp-configuring-schema-registry-metadata-stores-in-mysql.html 2020. 9. 17.
OpenLDAP + phpLDAPadmin ์„ค์น˜ ๋ฐ ์„ค์ • OpenLDAP LDAP ํ”„๋กœํ† ์ฝœ์„ ์‚ฌ์šฉํ•˜์—ฌ ๋””๋ ‰ํ† ๋ฆฌ(์‚ฌ์šฉ์ž/๊ทธ๋ฃน) ์ •๋ณด๋ฅผ ์ €์žฅํ•˜๊ณ  ๊ฒ€์ƒ‰ํ•˜๋Š” ์—ญํ• ์˜ ์„œ๋น„์Šค phpLDAPadmin OpenLDAP ์„œ๋ฒ„๋ฅผ ์›น ๊ธฐ๋ฐ˜์œผ๋กœ ๊ด€๋ฆฌํ•˜๊ธฐ ์œ„ํ•œ LDAP ํด๋ผ์ด์–ธํŠธ ์›น ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ 1. Install OpenLDAP $ sudo yum -y install openldap-servers openldap-clients $ sudo systemctl start slapd $ sudo systemctl status slapd $ sudo systemctl enable slapd $ sudo yum -y install net-tools $ sudo netstat -antup | grep -i 389 tcp 0 0 0.0.0.0:389 0.0.0.0:* LISTEN 8969/sl.. 2020. 9. 2.
[SOLVED] UnicodeDecodeError: 'ascii' codec can't decode byte 0xed in position 80: ordinal not in range(128) ๐Ÿšซ ERROR hue์—์„œ hive ์‚ฌ์šฉํ• ๋•Œ ํ•œ๊ธ€์„ insert ํ•˜๋ ค๋ฉด ์ธ์ฝ”๋”ฉ ๊ด€๋ จ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•˜๋Š”๋ฐ์š”. UnicodeDecodeError: 'ascii' codec can't decode byte 0xed in position 80: ordinal not in range(128) ๐Ÿ’ก SOLVED hue์—์„œ ์ฟผ๋ฆฌ๋ฅผ ์ฒ˜๋ฆฌํ• ๋•Œ ์‹คํ–‰๋˜๋Š” python ์ธ์ฝ”๋”ฉ ํƒ€์ž…์ด ascii๋กœ ์„ค์ •๋˜์–ด ์žˆ์–ด์„œ ๊ทธ๋ ‡์Šต๋‹ˆ๋‹ค. ํ•ด๋‹น ํŒŒ์ด์ฌ ์Šคํฌ๋ฆฝํŠธ ์ฐพ์•„์„œ ์ˆ˜์ • ํ›„ Hue ์žฌ๊ธฐ๋™ ํ•˜๋ฉด ๋ฉ๋‹ˆ๋‹ค. (ascii > utf-8) vi /opt/cloudera/parcels/CDH/lib/hue/build/env/lib/python2.7/site.py ----------------------------------------------------.. 2020. 7. 6.
[SOLVED] KeeperErrorCode = ConnectionLoss for /hbase ๐Ÿšซ ERROR HBase์—์„œ ConnectionLoss ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•ด์„œ zookeeper ๋กœ๊ทธ๋ฅผ ํ™•์ธํ•ด ๋ณด๋‹ˆ, Too many Connection ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•˜๊ณ  ์žˆ์—ˆ์Šต๋‹ˆ๋‹ค. ## Hbase Error KeeperErrorCode = ConnectionLoss for /hbase ## Zookeeper Error Too many connections from /x.x.x.x - max is 60 ๐Ÿ’ก SOLVED ๋‘ ๊ฐ€์ง€ ๋ฐฉ๋ฒ•์ด ์žˆ์Šต๋‹ˆ๋‹ค. 1. ์•„๋ž˜ ๋ช…๋ น์–ด๋กœ zookeeper์— ์ ‘์†ํ•˜๋Š” ํ”„๋กœ์„ธ์Šค๋ฅผ ํ™•์ธํ•˜๋ฉด ์•„๋ž˜ ๊ฒฐ๊ณผ์™€ ๊ฐ™์ด ํ•˜๋‚˜์— ํ”„๋กœ์„ธ์Šค์—์„œ ๋งŽ์€ connection์„ ์žก๊ณ  ์žˆ์Šต๋‹ˆ๋‹ค. ์ € ๊ฐ™์€ ๊ฒฝ์šฐ๋Š” Ranger์˜€๊ณ  Ranger ์žฌ๊ธฐ๋™ ํ›„ Zookeeper connection ์ˆ˜ 30 ๋ฐ‘์œผ๋กœ ์ค„์–ด ๋“ค์—ˆ์Šต๋‹ˆ.. 2020. 6. 17.
[zeppelin] hive interpreter ์—ฐ๋™ ๋ฐฉ๋ฒ• 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๋ฅผ ์„ค์ •ํ•ด ์ค๋‹ˆ.. 2020. 6. 12.
[Hadoop] ์‚ฌ์šฉ์ž HDFS ์ ‘๊ทผ ๊ถŒํ•œ ์„ค์ • ๋ฐฉ๋ฒ• (Ranger๊ฐ€ ์„ค์น˜๋˜์–ด ์žˆ์œผ๋ฉด Ranger์—์„œ ๊ด€๋ฆฌํ•˜๋Š”๊ฒŒ ์ข‹์Šต๋‹ˆ๋‹ค) https://heum-story.tistory.com/146 Apache Ranger ์‚ฌ์šฉ๋ฒ• Ranger ๊ฐ ๊ธฐ๋Šฅ๋“ค ์–ด๋–ป๊ฒŒ ์‚ฌ์šฉํ•˜๋Š”์ง€ ํ™•์ธํ•ด๋ณด๊ฒ ์Šต๋‹ˆ๋‹ค. Ranger๋ž€? ํ•˜๋‘ก ์ „์ฒด ์„œ๋น„์Šค์— ๋Œ€ํ•œ ๋ณด์•ˆ ์ •์ฑ…์„ ์ ์šฉํ•  ์ˆ˜ ์žˆ๊ณ  ๊ด€๋ฆฌ ๋ฐ ์šด์˜ํ•  ์ˆ˜ ์žˆ๋Š” ํ”„๋ ˆ์ž„์›Œํฌ์ž…๋‹ˆ๋‹ค. ํ•˜๋‘ก์˜ ๋ณด์•ˆ๊ด€๋ จ ์กฐ heum-story.tistory.com ๋ฆฌ๋ˆ…์Šค ์‚ฌ์šฉ์ž๋ฅผ hdfs์— ์ ‘๊ทผ ๊ถŒํ•œ ์„ค์ •ํ•˜๋Š” ๋‘๊ฐ€์ง€ ๋ฐฉ๋ฒ•์ž…๋‹ˆ๋‹ค. 1. ACL ๋ช…๋ น์–ด ์‚ฌ์šฉ hdfs-site.xml ์•„๋ž˜ ์„ค์ • ๋ณ€๊ฒฝํ•ด์•ผ ACL ์‚ฌ์šฉ๊ฐ€๋Šฅ dfs.namenode.acls.enabled= true ## root user๋ฅผ hdfs /user ๊ฒฝ๋กœ์— ์ฝ๊ธฐ,์“ฐ๊ธฐ,์‹คํ–‰ ๊ถŒํ•œ์„ ์คŒ hadoop fs -setf.. 2020. 5. 12.
[Hadoop] Number of Under Replicated Blocks ํ•ด๊ฒฐ๋ฐฉ๋ฒ• ํ…Œ์ŠคํŠธ ์šฉ๋„๋กœ DataNode๋ฅผ 2๋Œ€๋กœ ๊ตฌ์„ฑํ–ˆ๋Š”๋ฐ, ์ดˆ๊ธฐ ์„ค์น˜ ๋•Œ ๊ธฐ๋ณธ replication ์„ค์ •์ด 3์ด๊ธฐ ๋•Œ๋ฌธ์— ๋ฐœ์ƒํ•œ ๋‚ด์šฉ์œผ๋กœ ์„ค์น˜ ํ›„ replication์„ 2๋กœ ๋ณ€๊ฒฝํ–ˆ์Šต๋‹ˆ๋‹ค. ## Under replicated ํŒŒ์ผ ๊ฒฝ๋กœ ๋ชฉ๋ก ์ €์žฅ $ hdfs fsck / | grep 'Under replicated' | awk -F':' '{print $1}' > /tmp/under_replicated_files ## ์ค‘๋ณต ํ–‰ ์ œ๊ฑฐ $ sort -u /tmp/under_replicated_files > /tmp/under_replicated_files_sort ## shell ์Šคํฌ๋ฆฝํŠธ ์ƒ์„ฑ $ vi run_set_replication.sh ----------------------------------------.. 2020. 4. 5.
Ambari HDP component ์‚ญ์ œ ํ›„ ์žฌ์„ค์น˜ ๐Ÿ’ก Ambari HDP ์—์ฝ”์‹œ์Šคํ…œ์— ๋ฌธ์ œ๊ฐ€ ๋ฐœ์ƒํ•ด ํ•ด๋‹น ์„œ๋น„์Šค๋ฅผ ์‚ญ์ œ ํ›„ ์žฌ์„ค์น˜ ๋ฐฉ๋ฒ• ์•„๋ž˜ ๋ช…๋ น์–ด ์‹คํ–‰ ํ›„ ambari์—์„œ ์žฌ์„ค์น˜ ์ง„ํ–‰ํ•ด์ฃผ๋ฉด ๋ฉ๋‹ˆ๋‹ค. $ rm -rf /usr/hdp/2.6.5.1175-1/ranger-kms $ rm -rf /etc/ranger/kms $ yum remove ranger_2_6_5_1175_1-kms.x86_64 2020. 2. 28.