none
Hive activity error

    Question

  • Hi Team

    How do i deal with such case

    ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
    LOCATION '${hiveconf:storageEndpoint}/Production.ScrapReason.txt/';

    my storageEndpoint is a blob storage

    it gives an error for when i try using .txt extension for reading the data from the file.

    if i remove the .txt extension it creates a new file with no data in it.

    Regards,

    Alrick

    Thursday, July 19, 2018 12:07 PM

All replies

  • Hi Alrick,

    What error are you getting?

    I see references to problems with loading data to or from ORC tables to txt files, for example:

    https://stackoverflow.com/questions/21721251/loading-data-from-a-txt-file-to-table-stored-as-orc-in-hive

    Thursday, July 19, 2018 6:23 PM
    Moderator