如果确实想写和Oracle中等价的查询:
SELECT * FROM T001 WHERE COL1 LIKE ‘ABC\\%’;
建议在Hive中用正则实现:
SELECT * FROM T001 WHERE COL1 REGEXP ‘^ABC\\’;
如果确实想写和Oracle中等价的查询:
SELECT * FROM T001 WHERE COL1 LIKE ‘ABC\\%’;
建议在Hive中用正则实现:
SELECT * FROM T001 WHERE COL1 REGEXP ‘^ABC\\’;