Hive does not support SQL Server's CHARINDEX() function. In your 2nd query you are using INSTR() but the arguments are reversed. Change to:
確定! 回上一頁