none
Cannot drop / recreate table on local ADLA Database

    Question

  • Hi all,

    After some time troubleshooting, I realized that I can only drop a local table if I drop and recreate the entire Database First.

    - Right click delete on Data Lake Analytics -> (local) -> Databases -> Tables -> MyTable doesn't do anything.

    - DROP TABLE IF EXISTS ... MyTable returns "Execution failed with error 'MetaDataExecutor returned with '-3''"

    Is this expected ??

    Tuesday, June 7, 2016 9:58 PM

Answers

All replies

  • Dear amihanov

    My apologies for the late reply but I am just catching up after a vacation.

    DROP TABLE IF EXISTS should work and works for me. Are you in the right database and schema context?

    Are you running the job locally or against a cluster?

    Can you paste the full error message you are getting?


    Michael Rys

    Thursday, June 16, 2016 12:36 AM
    Moderator
  • Dear amihanov,

    I'm sorry for the late response. This is a recently found bug in local metadata management and we have fixed it in the June update.   Please try to get the latest update from here:

    http://aka.ms/adltoolsVS

    Thanks a lot,

    Yu Dong

    Monday, June 20, 2016 2:13 AM