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

๐Ÿ’ปTech159

Docker custom image ์ƒ์„ฑ ๋ฐฉ๋ฒ• (with CDSW) 1. Dockerfile ์ƒ์„ฑ $ vi Dockerfile ------------------------------------------------------------------- # Dockerfile # Specify a Cloudera Data Science Workbench base image FROM docker.repository.cloudera.com/cdsw/engine:13 # Update packages on the base image and install beautifulsoup4 RUN pip3 install beautifulsoup4 ------------------------------------------------------------------- 2. Dockerfile b.. 2021. 1. 8.
kudu ๋ช…๋ น์–ด ์ •๋ฆฌ โ—พ ํ…Œ์ด๋ธ” ์ƒ์„ฑ (as select) CREATE TABLE temp.kudu_cm_audits PRIMARY KEY (audit_id) STORED AS KUDU TBLPROPERTIES ('kudu.num_tablet_replicas' = '1') AS SELECT * FROM temp.cm_audits ; โ—พ ํ…Œ์ด๋ธ” ์ƒ์„ฑ (range partition) CREATE TABLE IF NOT EXISTS temp.kudu_sample( gubun string, seq int, code string, description string, total_emp int, salary int, PRIMARY KEY(gubun,seq) ) PARTITION BY RANGE(gubun)( PARTITION VALUE .. 2020. 12. 23.
[NiFi] Impala JDBC DBCPConnectionPool ์‚ฌ์šฉ ์˜ˆ์ œ 1. Impala JDBC Connector ๋‹ค์šด๋กœ๋“œ https://www.cloudera.com/downloads/connectors/impala/jdbc/2-6-17.html 2. NiFi DBCPConnectionPool ์„ค์ • Database Driver Location(s) ์—…๋กœ๋“œํ•œ ํŒŒ์ผ ๊ฒฝ๋กœ ์ž…๋ ฅ /opt/cloudera/parcels/CFM/NIFI/lib/ImpalaJDBC42.jar ๊ฒฝ๋กœ๋ฅผ ์ง€์ •ํ•˜์ง€ ์•Š์„ ๊ฒฝ์šฐ ์•„๋ž˜์™€ ๊ฐ™์€ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•จ Validation query ์ž…๋ ฅํ•ด์ฃผ๋ฉด ์ข‹์Œ (select 1) Could not initialize class com.cloudera.impala.jdbc42.internal.apache.thrift.transport.TSocket 3. Impala SQ.. 2020. 10. 14.
์ฟ ๋ฒ„๋„คํ‹ฐ์Šค ๋ช…๋ น์–ด (with CDSW) โ—พ ์ฟ ๋ฒ„๋„คํ‹ฐ์Šค pod ๋ฆฌ์ŠคํŠธ ์กฐํšŒ kubectl get pods --all-namespaces -o wide โ—พ pod ์ ‘์† kubectl exec -it ํŒŸ์ด๋ฆ„ -n ๋„ค์ž„์ŠคํŽ˜์ด์Šค /bin/bash ex) kubectl exec -it 5w1ixw5q39iqvcfi -n default-user-1 /bin/bash โ—พ pod ๋กœ๊ทธ ํ™•์ธ ๋ฐฉ๋ฒ• ## f ์˜ต์…˜์€ ์‹ค์‹œ๊ฐ„ ํ™•์ธ kubectl logs -f 5w1ixw5q39iqvcfi -n default-user-1 ## pod init ๋กœ๊ทธ ํ™•์ธ (Init:CrashLoopBackOff, Init:Error ๋ฐœ์ƒํ•  ๋•Œ ํ™•์ธ) ## init-container name์€ describe ๋ช…๋ น์–ด ์‹คํ–‰์œผ๋กœ ํ™•์ธ ๊ฐ€๋Šฅ kubectl logs 5w1ixw5q39iqvcf.. 2020. 10. 13.
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.
Websocket connection failed ws:// err_name_not_resolved ๐Ÿšซ ERROR Websocket connection failed ws://ex.websocket.com err_name_not_resolved ๐Ÿ’ก SOLVED ์ ‘์†ํ•˜๋Š” PC์˜ hosts ํŒŒ์ผ์— ํ•ด๋‹น ํ˜ธ์ŠคํŠธ๋ช…๊ณผ IP๋ฅผ ์ž…๋ ฅํ•ด์ค๋‹ˆ๋‹ค. C:\Windows\System32\drivers\etc\hosts ํŒŒ์ผ ์—ด์–ด์„œ ์•„๋ž˜ ๋‚ด์šฉ ์ž…๋ ฅ 128.x.x.1 ex.websocket.com 2020. 9. 10.
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.