Not able to query data with special character in hive or Presto

0
votes

Data is residing in parquet format. Parquet support the column name to have '[' bracket. Also able to create the table in hive with same column name. But select of column is failing.

Is there any way to handle special character '[]' in column name in hive or Presto?

1
hivehiveqlpresto

1 Answers

3
votes

You can use double-quote on Presto and back-quote on Hive:

-- Presto
SELECT 1 as "[name]"

-- Hive
SELECT 1 as `[name]`