title: How to specify SERDEPROPERTIES and TBLPROPERTIES when creating Hive table via prestosql
body: <p>I'm trying to follow the examples of <a href="https://prestosql.io/docs/current/connector/hive.html#examples" rel="nofollow noreferrer">Hive connector</a> to create hive table. I can write HQL to create a table via beeline. But wonder how to make it via prestosql.</p>
  
  <p>Given table </p>
  
  <pre><code>CREATE TABLE hive.web.request_logs (
    request_time varchar,
    url varchar,
    ip varchar,
    user_agent varchar,
    dt varchar
  )
  WITH (
    format = 'CSV',
    partitioned_by = ARRAY['dt'],
    external_location = 's3://my-bucket/data/logs/'
  )
  </code></pre>
  
  <ol>
  <li>How to specify <code>SERDEPROPERTIES</code> like <code>separatorChar</code> and <code>quoteChar</code>?</li>
  <li>How to specify <code>TBLPROPERTIES</code> like <code>skip.header.line.count</code>?</li>
  </ol>