7

Suppose I want to INSERT INTO a static hive partition, can I do that with Presto?

The PARTITION keyword is only for hive.

INSERT INTO TABLE Employee PARTITION (department='HR')

Caused by: com.facebook.presto.sql.parser.ParsingException: line 1:44: mismatched input 'PARTITION'. Expecting: '(', at com.facebook.presto.sql.parser.ErrorHandler.syntaxError(ErrorHandler.java:109)

leftjoin
  • 36,950
  • 8
  • 57
  • 116
Tiberiu
  • 990
  • 2
  • 18
  • 36

1 Answers1

5

In Presto you do not need PARTITION(department='HR').

INSERT INTO Employee (name, department)
VALUES  ('John', 'HR');

or

INSERT INTO Employee (name, department)
select 
      name, 
      'HR' 
from 
...
leftjoin
  • 36,950
  • 8
  • 57
  • 116
  • 1
    INSERT INTO is good enough. TABLE clause is not needed – ShikharDua Feb 24 '22 at 23:53
  • This works, everybody. Make sure to use single quotes in presto, I just spent several minutes trying to figure out what didn't work, turns out presto didn't like double quotes. – pavel_orekhov Aug 09 '23 at 22:12