title: Unable to select data from AWS Athena table
body: <p>I have created a table in Athena using below SQL</p>
  <pre><code>CREATE EXTERNAL TABLE IF NOT EXISTS xyzschema.my_table (
    `col1` string,
    `col2` string
  )
  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
  WITH SERDEPROPERTIES (
    'serialization.format' = ',',
    'field.delim' = ','
  ) LOCATION 's3://temp/my_table_data/'
  TBLPROPERTIES ('has_encrypted_data'='false'); 
  </code></pre>
  <p>Post creation of table when I try to query from the table</p>
  <pre><code>select 'col1' from &quot;my_table&quot;
  </code></pre>
  <p>I am getting the following error , not really sure what permission is missing</p>
  <p>Your query has the following error(s):</p>
  <pre><code>Insufficient permissions to execute the query. Principal does not have any privilege on specified resource
  </code></pre>
  <p>If I run the following</p>
  <pre><code>select * from &quot;gleif_data_master_csv&quot;
  </code></pre>
  <p>I get the below error</p>
  <pre><code>SYNTAX_ERROR: line 1:8: SELECT * not allowed in queries without FROM clause
  </code></pre>
  <p>Any suggestions/ideas why this is breaking ?</p>