如何仅获取分配给“ USA_RBB_WA_BU”的“ _WA”数据的数据? 但是,我查看的列中的行包含_WA和_SA(USA_CA_SAWANT)
我用过,
select....
'USA_RBB_WA_BU' AS State,District
from TABLE where district like '%_WA%'
select ...
'USA_RBB_NSW_BU' AS State,District
from TABLE where district like '%_SA%'
但是我最终得到下面的数据输出表
**state district**
USA_RBB_NSW_BU USA_CA_SAWANT
USA_RBB_WA_BU USA_CA_SAWANT
USA_RBB_NSW_BU USA_CA_SAWANT
USA_RBB_WA_BU USA_CA_SAWANT
我尝试了
select....
'USA_RBB_WA_BU' AS State,District
from TABLE where district like '_WA%'
output was was 0 results in hive