Hi, trying to setup a CDP Hive ImportJob with the following select query with limit 2 but getting an error. Anyone facing this problem?
select * FROM abc.table1 limit 2
Can not parse input: Error while compiling statement: FAILED: ParseException line 1:46 cannot recognize input near 'limit' '2' 'LIMIT' in limit clause
Please sign in to leave a comment.