title: cannot recognize input near 'SELECT' 'DISTINCT' '(' in expression specification -Hive
body: <p>Trying to execute below query in hive. throwing exception cannot recognize input near 'SELECT' 'DISTINCT' '(' in expression specification. any help is appreciated.  </p>
  
  <pre><code>SELECT DISTINCT (FISCAL_QUARTER_START_DATE)
        FROM TEST_STAGE.TEST_TABLE
       WHERE     FISCAL_YEAR_ID =
                    (SELECT FISCAL_YEAR_ID
                       FROM TEST_STAGE.TEST_TABLE
                      WHERE CALENDAR_DATE = FROM_UNIXTIME (UNIX_TIMESTAMP ()))
             AND SUBSTR (FISCAL_QUARTER_NAME, 0, 2) =
                    (SELECT SUBSTR (FISCAL_QUARTER_NAME, 0, 2)
                       FROM TEST_STAGE.TEST_TABLE
                      WHERE CALENDAR_DATE = FROM_UNIXTIME (UNIX_TIMESTAMP ()))
  </code></pre>
  
  <p>Thanks</p>