1

Is there any functionality to create a temporary table in presto SQL? Can't seem to find it in the documentation . Otherwise, is the best option just to create a regular table and drop it immediately after?

information_interchange
  • 2,538
  • 6
  • 31
  • 49

1 Answers1

1

You're not missing anything -- there is no CREATE TEMP TABLE that automagically destroys the object based on session scope, etc.

Your idea is a good one. Another approach that some folks take is using the in-memory connector for this work. YMMV since that connector isn't super-robust.

Russell Christopher
  • 1,677
  • 3
  • 20
  • 36