https://www.letmecompile.com/kafka-consumer-offset-reset/ 카프카(Kafka) Consumer offset reset 방법 카프카 Consumer를 사용하다 보면 offset을 reset해야하는 경우가 종종 있다. 개발 테스트를 진행하다가 필요에의해 offset을 리셋 실제 production에서 사용중에 예상치 못한 에러 등으로 데이터 누락이 � www.letmecompile.com https://coding-start.tistory.com/137 Kafka - Kafka Consumer(카프카 컨슈머) Java&CLI Kafka - Kafka Consumer(카프카 컨슈머) Java&CLI 이전 포스팅에서 kafka producer를 java 소스기반으로 ..
SELECT id, sum(Jan_Revenue) Jan_Revenue, sum(Feb_Revenue) Feb_Revenue, sum(Mar_Revenue) Mar_Revenue, sum(Apr_Revenue) Apr_Revenue, sum(May_Revenue) May_Revenue, sum(Jun_Revenue) Jun_Revenue, sum(Jul_Revenue) Jul_Revenue, sum(Aug_Revenue) Aug_Revenue, sum(Sep_Revenue) Sep_Revenue, sum(Oct_Revenue) Oct_Revenue, sum(Nov_Revenue) Nov_Revenue, sum(Dec_Revenue) Dec_Revenue FROM ( SELECT id, CASE WHEN ..
https://spark.apache.org/docs/3.0.0-preview/sql-ref-syntax-aux-show-tables.html SHOW TABLES - Spark 3.0.0-preview Documentation You are using an outdated browser. Upgrade your browser today or install Google Chrome Frame to better experience this site. Overview Programming Guides API Docs Deploying More v3.0.0-preview --> spark.apache.org
@ToString(callSuper=true, includeFieldNames=false) public String csv() { String name = this.toString(); name = name.replace(MergeResult.class.getSimpleName(), ""); name = name.substring(1, name.length()-1); name = name.replaceAll(CommonUtils.DELIMITER+" ", CommonUtils.DELIMITER); return name; } public static String fields() { return Arrays.stream(MergeResult.class.getDeclaredFields()) .map(Field..
import os from flask import Flask,redirect app = Flask(__name__) @app.route('/') def hello(): return redirect("http://www.example.com", code=302) if __name__ == '__main__': # Bind to PORT if defined, otherwise default to 5000. port = int(os.environ.get('PORT', 5000)) app.run(host='0.0.0.0', port=port) https://stackoverflow.com/questions/14343812/redirecting-to-url-in-flask Redirecting to URL in ..
from datetime import timedelta, date KST = date.today() + timedelta(hours=9) https://stackoverflow.com/questions/6871016/adding-5-days-to-a-date-in-python Adding 5 days to a date in Python I have a date "10/10/11(m-d-y)" and I want to add 5 days to it using a Python script. Please consider a general solution that works on the month ends also. I am using following code: import re from stackoverfl..
yum install -y python3-devel.x86_64 https://stackoverflow.com/questions/43047284/how-to-install-python3-devel-on-red-hat-7 How to install python3-devel on red hat 7 I am trying to install something in my virtual environment, which uses anaconda python 3.6. I get the gcc failed with exit status 1, hinting on the absence of the right python3-devel package, as stackoverflow.com
https://stackoverflow.com/questions/11704327/how-to-optimize-imports-automatically-after-each-save-in-intellij-idea How to optimize imports automatically after each save in IntelliJ IDEA I want to learn how can I automatically optimize imports after each save as we do Eclipse(save actions). stackoverflow.com
ALTER TABLE table1 ADD COLUMN foo INT DEFAULT 0; https://stackoverflow.com/questions/3569347/adding-a-new-sql-column-with-a-default-value Adding a new SQL column with a default value I am looking for the syntax to add a column to a MySQL database with a default value of 0 Reference stackoverflow.com
### AS-IS DELETE FROM cwd_group WHERE id IN (SELECT DISTINCT a.id ext_id FROM cwd_group a JOIN cwd_group b ON a.group_name=b.group_name JOIN cwd_directory d ON d.id=a.directory_id WHERE a.directory_id != b.directory_id AND directory_name = 'My JIRA Server'); ### TO-BE DELETE FROM cwd_group WHERE id IN (SELECT ext_id FROM (SELECT DISTINCT a.id ext_id FROM cwd_group a JOIN cwd_group b ON a.group_n..
UPDATE table_name SET field = REPLACE(field, 'foo', 'bar') WHERE INSTR(field, 'foo') > 0; https://stackoverflow.com/questions/125230/mysql-search-and-replace-some-text-in-a-field MySQL search and replace some text in a field What MySQL query will do a text search and replace in one particular field in a table? I.e. search for foo and replace with bar so a record with a field with the value hello..
brew update brew tap mongodb/brew brew install mongodb-community@4.0 brew services start mongodb-community@4.0 ~/.zshrc export PATH="$PATH:/usr/local/Cellar/mongodb-community@4.0/4.0.18/bin" https://velog.io/@rosewwross/MongoDB-%EC%B4%88%EA%B8%B0%EC%84%A4%EC%A0%95-%EB%B0%8F-%EC%BF%BC%EB%A6%AC%EB%AC%B8-%EC%A0%95%EB%A6%AC (MongoDB) 초기설정 및 쿼리문 정리 설정 참고: https://treehouse.github.io/installation-guid..
https://stackoverflow.com/questions/37696950/spring-using-value-annotation-in-filter Spring using @Value annotation in Filter I am currently working on a Spring project and I am making a new filter that checks if a valid JWT has been sent in the request. I am running into an issue where I can't get a value from my applic... stackoverflow.com
https://junho85.pe.kr/1483 Jetbrains DataGrip - MySQL Timezone 접속문제 해결. Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTi DataGrip에서 MySQL 서버에 접속하려고 하니 "Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' property manually."가 뜨면서 DB 접속이 안되었습니다. 물론 Advanced 탭에서.. junho85.pe.kr