dplyr 설치 및 PostgreSQL PL/R 테스트

📦 dplyr 설치를 위한 종속 라이브러리 설치

# tibble 관련 패키지
sudo R CMD INSTALL /data1/staging/R_lib/dplyr/tibble/pillar/utf8_1.2.5.tar.gz
sudo R CMD INSTALL /data1/staging/R_lib/dplyr/tibble/pillar_1.10.2.tar.gz
sudo R CMD INSTALL /data1/staging/R_lib/dplyr/tibble/pkgconfig_2.0.3.tar.gz
sudo R CMD INSTALL /data1/staging/R_lib/dplyr/tibble/magrittr_2.0.3.tar.gz
sudo R CMD INSTALL /data1/staging/R_lib/dplyr/tibble/fansi_1.0.6.tar.gz
sudo R CMD INSTALL /data1/staging/R_lib/dplyr/tibble_3.2.1.tar.gz

# tidyselect 관련 패키지
sudo R CMD INSTALL /data1/staging/R_lib/dplyr/tidyselect/withr_3.0.2.tar.gz
sudo R CMD INSTALL /data1/staging/R_lib/dplyr/tidyselect_1.2.1.tar.gz

# 기타 의존 패키지
sudo R CMD INSTALL /data1/staging/R_lib/dplyr/R6_2.6.1.tar.gz
sudo R CMD INSTALL /data1/staging/R_lib/dplyr/generics_0.1.3.tar.gz

# dplyr 설치
sudo R CMD INSTALL /data1/staging/R_lib/dplyr/dplyr_1.1.4.tar.gz

✅ dplyr 설치 확인 (R 콘솔)

library(dplyr)
cat("dplyr version:", as.character(packageVersion("dplyr")), "\n")

출력 예:

dplyr version: 1.1.4

🧪 PostgreSQL PL/R 테스트 함수

CREATE OR REPLACE FUNCTION dplyr_test() RETURNS text AS $$
  library(dplyr)

  df <- data.frame(
    category = c("A", "B", "A", "B", "A"),
    value = c(10, 20, 15, 25, 30)
  )

  result <- df %>%
    group_by(category) %>%
    summarise(total = sum(value), .groups = "drop")

  result <- as.data.frame(result)

  paste(capture.output(print(result)), collapse = "\n")
$$ LANGUAGE plr;

🧾 실행 결과

SELECT dplyr_test();

 category total
 1        A    55
 2        B    45
(1 row)