walterddr commented on PR #8557: URL: https://github.com/apache/pinot/pull/8557#issuecomment-1104437034
to add to it. `LOAD FILE` seems to be a MySQL only standard. for example PostgresDB: - `LOAD` keyword is used to load sharelib https://www.postgresql.org/docs/current/sql-load.html - `INSERT` + `COPY` seems to be used for loading files into table: https://www.postgresql.org/docs/current/sql-insert.html , https://www.postgresql.org/docs/14/sql-copy.html and if we view the `COPY` syntax it is very similar to the proposed syntax: ``` COPY table_name [ ( column_name [, ...] ) ] FROM { 'filename' | PROGRAM 'command' | STDIN } [ [ WITH ] ( option [, ...] ) ] [ WHERE condition ] ``` where the `FROM { 'filename' }` part represents an external table from a file. -- 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: commits-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
