개발잡부

https://spark.apache.org/docs/latest/sql-data-sources-load-save-functions.html Generic Load/Save Functions - Spark 3.2.1 Documentation spark.apache.org JSON File 읽기 Dataset peopleDF = spark.read().format("json").load("examples/src/main/resources/people.json"); peopleDF.select("name", "age").write().format("parquet").save("namesAndAges.parquet"); CSV File 읽기 Dataset peopleDFCsv = spark.read().for..

https://sparkbyexamples.com/spark/install-apache-spark-on-mac/ Install Apache Spark Latest Version on Mac - Spark by {Examples} Five easy steps to install the latest version of Apache Spark on Mac (macOS) – In recent days Apache Spark installation on Mac OS has become very easy using Homebrew. You can install it and start running examples in just 5 mins. There are multiple ways t sparkbyexamples..

//스트림 생성 //컬렉션 List list = Arrays.asList("a", "b", "c"); Stream stream = list.stream(); //배열 String[] array = new String[]{"a","b","c"}; Stream stream1 = Arrays.stream(array); Stream stream2 = Arrays.stream(array, 1, 3); //정적메소드 Arrays.stream() 에 인자를 입력 //인덱스 1 포함, 3제외 //빌더 Stream stream3 = Stream.builder().add("a").add("b").build(); //Generator Stream stream4 = Stream.generate(()->"a").limit(3)..

우선 if 문 select * from tbl_board where title = '%'||#{title}||'%' OR content = '%'||#{content}||'%' and or 조건문 switch case -- doo 인 경우 재고수량 , iisales.remain_cnt -- 재고수량 , (SELECT remain_cnt FROM itm_item_sales WHERE item_no = ii .item_no AND if (iiss.stock_allot_type = 'ALL' iiss. online_stock_yn ='Y' iiss. online_stock_start_dt now() now() iiss. online_stock_end_dt , store_id ='99998' , store_id..

11:14:56 ### Error querying database. Cause: java.sql.SQLException: Error retrieving record: Unexpected Exception: java.io.EOFException message given: Can not read response from server. Expected to read 475 bytes, read 463 bytes before connection was unexpectedly lost. #autoReconnectForPools 옵션 autoReconnectForPools=true url: jdbc:mysql://{host}:{port}/{DB}?useUnicode=true&useCursorFetch=true&ch..

package com.bbongdoo.doo.keyword; import com.bbongdoo.doo.domain.Keywords; import com.bbongdoo.doo.domain.KeywordsRepository; import com.bbongdoo.doo.service.KeywordsService; import org.assertj.core.api.Assertions; import org.junit.jupiter.api.BeforeEach; import org.junit.jupiter.api.Test; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.context..

Annotation package com.bbongdoo.doo.annotation; import java.lang.annotation.ElementType; import java.lang.annotation.Retention; import java.lang.annotation.RetentionPolicy; import java.lang.annotation.Target; @Target({ElementType.TYPE, ElementType.METHOD}) @Retention(RetentionPolicy.RUNTIME) public @interface Timer { } Aspect package com.bbongdoo.doo.aspect; import org.aspectj.lang.ProceedingJoi..

한개의 컬럼에 UNIQUE 설정 @Column(name="column" , unique=true) long column 두 개 이상 컬럼을 묶어 UNIQUE 설정 @Table 속성 uniqueConstraints 사용 @Entity @Table( name="keywords", uniqueConstraints={ @UniqueConstraint( name={"contstraintName"} columnNames={"keyword", "use_yn"} ) } ) @Data public class Entity{ @Column(name="keyword") String keyword; @Column(name="use_yn") String use_yn; } http://iryan.kr/t7eogjtthy 농심 먹태..

Table 'shop.hibernate_sequence' doesn't exist @GeneratedValue(strategy = GenerationType.IDENTITY) https://mkyong.com/spring-boot/spring-boot-mysql-table-db_name-hibernate_sequence-doesnt-exist/ spring.jpa.hibernate.use-new-id-generator-mappings=false

drop table if exists rooms; drop table if exists room_members; drop table if exists user_account; drop table if exists users; drop table if exists balance_send; drop table if exists balance_receive; CREATE TABLE `rooms` ( `id` bigint NOT NULL AUTO_INCREMENT, `room_id` varchar(3) NOT NULL, `room_name` varchar(100) NOT NULL, `category1` varchar(100) DEFAULT NULL, `category2` varchar(100) DEFAULT N..