티스토리 뷰

공부

[Spark] order by 한글 > 영어 > 숫자

승가비 2020. 10. 27. 20:23
728x90
SELECT *
FROM t
ORDER BY 
  (CASE 
    WHEN SUBSTRING(name,1,1) RLIKE '[ㄱ-ㅎ가-힣]' THEN 1
    WHEN SUBSTRING(name,1,1) RLIKE '[a-zA-Z]' THEN 2
    ELSE 3
  END),
  name

https://solbel.tistory.com/429

 

[sql] mysql 데이터 정렬 - 오름차순, 한글-영문-숫자 순서

[sql] mysql 데이터 정렬 - 오름차순, 한글-영문-숫자 순서 * MySQL에서 처리  SELECT * FROM tb_ncc_new_category  WHERE service_enable_mobile = 'Y'  AND category_type = 'magazine' ORDER BY (CAS..

solbel.tistory.com

https://spark.apache.org/docs/2.3.0/api/sql/#rlike

 

Functions - Spark SQL, Built-in Functions

  Spark SQL, Built-in Functions Docs » Functions ! ! expr - Logical not. % expr1 % expr2 - Returns the remainder after expr1/expr2. Examples: > SELECT 2 % 1.8; 0.2 > SELECT MOD(2, 1.8); 0.2 & expr1 & expr2 - Returns the result of bitwise AND of expr1 and

spark.apache.org

 

728x90
댓글