Hi - I know how to SKIP the first X lines in Vertica using the COPY statement, but is there a way to determine how to skip the LAST 1-2 lines? The last 1-2 lines (depending on the file) in my data file represent the timestamp of the file generation.
If the COPY command cannot do it -- I'll have to do it programatically which is fine -- but I'm wondering if the COPY command has the ability to ignore "footer" data.
Thanks!
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.