Help using Base SAS procedures

Hadoop Hive - Proc Sort

Reply
Contributor
Posts: 65

Hadoop Hive - Proc Sort

Hi All,

I am a newbie hadoop/hive sas user and I am trying to run a simple proc sort on a hive table and somehow it's throwing error. Here's my program:

proc sort data = hive.mytable out = mytable;

by keyabc keyxyz;

run;

Error Report:

ERROR: java.sql.SQLException: Error while compiling statement: FAILED: SemanticException 1:453 In strict mode, if ORDER BY is

       specified, LIMIT must also be specified. Error encountered near token 'keyabc'

ERROR: java.sql.SQLException: Error while compiling statement: FAILED: SemanticException 1:277 In strict mode, if ORDER BY is

       specified, LIMIT must also be specified. Error encountered near token 'keyabc'

ERROR: Unable to execute Hadoop query.

Can you please help me understand, what I am doing wrong?

Ask a Question
Discussion stats
  • 0 replies
  • 354 views
  • 0 likes
  • 1 in conversation