boneanxs commented on PR #9986: URL: https://github.com/apache/hudi/pull/9986#issuecomment-1794455135
> > > can not cache tempview for read_optimized or snapshot > > > > > > Can I directly call `cache table $view_name` to cache it? > > in sparksession can not do it，because all job are by sql srcipts，need cache it by the way @boneanxs We can use cache query for view, can see https://spark.apache.org/docs/latest/sql-ref-syntax-aux-cache-cache-table.html for examples. Besides, I'm not prefer to add extra flag in procedure to explicitly cache the view, users who uses this procedure will also perform other queries on the view created, it's a common sense that they cache the view if they want better query performance by using cache command. So here I actually don't see any specific benefits this extra flag can provide. Moreover, If users want other `StorageLevel` or lazily cache the view, then this flag cannot help that. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
