Hello! By a virtual column we were thinking something similar to ‘INPUT__FILE__NAME’ seen here: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+VirtualColumns
Our idea was to add an extra column with some metadata that could be useful to the user for time-travel queries. I hope that clarifies my question a bit, thanks for your reply! 😊 Christine From: Mich Talebzadeh <mich.talebza...@gmail.com> Reply to: "user@hive.apache.org" <user@hive.apache.org> Date: Wednesday, 6 May 2020 at 17:11 To: user <user@hive.apache.org> Subject: Re: Adding a virtual column for a custom input format Hi Christine. Virtual column meaning a derived column? can you achieve this by creating a view on Hive table? HTH Dr Mich Talebzadeh LinkedIn https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw http://talebzadehmich.wordpress.com Disclaimer: Use it at your own risk. Any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on this email's technical content is explicitly disclaimed. The author will in no case be liable for any monetary damages arising from such loss, damage or destruction. On Wed, 6 May 2020 at 16:54, Christine Mathiesen <t-cmathie...@hotels.com<mailto:t-cmathie...@hotels.com>> wrote: Hello! I'm hoping someone can help me shed some light on how Hive deals with virtual columns. We are trying to implement some time travel features in a custom input format we're building and are considering the approach of adding a virtual column, but I haven't been able to find much information on Hive's implementation. Any help or links on how we can add our own virtual column to a Hive table would be very appreciated! Thank you! Christine Mathiesen Software Development Intern BDP – Hotels.com Expedia Group
