[hive] bad error reporting if a FROM is missing in the nested query in case of JOIN -----------------------------------------------------------------------------------
Key: HADOOP-4518 URL: https://issues.apache.org/jira/browse/HADOOP-4518 Project: Hadoop Core Issue Type: Bug Reporter: Namit Jain EXPLAIN FROM (SELECT DISTINCT C_CXT.USERID FROM C_CXT) A JOIN (SELECT FCT_INVITES.* WHERE FCT_INVITES.INVITER_ID <> 0 AND FCT_INVITES.DS = '2008-10-01') B ON (A.USERID = B.INVITER_ID) SELECT B.* The above is missing FROM in the 2nd subquery (B), but the parser returns an error in JOIN -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.