Uploaded image for project: 'Apache AsterixDB'
  1. Apache AsterixDB
  2. ASTERIXDB-2984

LOAD not throwing error for bad input

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • ING - Ingestion
    • None

    Description

      LOAD is not throwing a warning for malformed input, but querying the data using an external dataset does.

      -- This throws the expected warning...
      DROP    DATAVERSE MuVI IF EXISTS;
      CREATE  DATAVERSE MuVI;
      USE     MuVI;
      CREATE  TYPE ResultsType AS { };
      CREATE  EXTERNAL DATASET ResultsDataset (ResultsType)
      USING   localfs (
        ("path"="127.0.0.1:///..../2021-11-12.json"),  
        ("format"="json")
      );FROM    ResultsDataset
      SELECT  COUNT(*);
      
      -- This does not...
      DROP    DATAVERSE MuVI IF EXISTS;
      CREATE  DATAVERSE MuVI;
      USE     MuVI;
      CREATE  TYPE ResultsType AS { _id: UUID };
      CREATE  DATASET ResultsDataset (ResultsType) PRIMARY KEY _id AUTOGENERATED;
      LOAD    DATASET ResultsDataset
      USING   localfs (
        ("path"="127.0.0.1:///..../2021-11-12.json"),  
        ("format"="json")
      ); 

      Attachments

        1. 2021-11-12.json
          3.38 MB
          Glenn Justo Galvizo

        Activity

          People

            imaxon Ian Maxon
            ggalvizo Glenn Justo Galvizo
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: