时间戳

首页 > 解决方案 > 需要找到连接结果与 concat(column1, column2) 匹配的所有结果

sql - 需要找到连接结果与 concat(column1, column2) 匹配的所有结果

问题描述

我需要为那些我拥有的连接列表与concat(car_number, penalty_date)

select car_number, crn, city, rulename,dt from hive.trust.fraud_crns_consolidated_reporting  
where (select concat(car_number,penalty_date) as "Concatenation") in
('svvsvsvs25072019-08-25')

结果：

Car_number crn    city       rulename  dt 
svvsvsvs   33334  Bangalore   dd2      2019-08-25

标签： sqlhive

解决方案

您可以像这样使用子查询：

Select * 
from
    (select car_number, crn, city, rulename,dt, concat(car_number,penalty_date) as "Concatenation"
     from hive.trust.fraud_crns_consolidated_reporting
    ) t
where t.Concatenation = 'XDFDFD2019-09-01'

或者在 where 子句中使用 concat

select car_number, crn, city, rulename,dt, concat(car_number,penalty_date) as "Concatenation"
from hive.trust.fraud_crns_consolidated_reporting 
where concat(car_number,penalty_date) = 'XDFDFD2019-09-01'

干杯！！

推荐阅读