[jira] [Created] (DRILL-7897) Cannot query PageBlobs from Azure Blob Storage V2

["Benney Au (Jira)" <ji...@apache.org>]

Benney Au created DRILL-7897:
--------------------------------

             Summary: Cannot query PageBlobs from Azure Blob Storage V2
                 Key: DRILL-7897
                 URL: https://issues.apache.org/jira/browse/DRILL-7897
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.18.0
         Environment: {color:#d1d2d3}I'm trying to connect drill to Azure Blob Storage and query some subfolders.{color}
{color:#d1d2d3}using drill-1.18.0.{color}
{color:#d1d2d3}I've setup the storage plugin and I get these results when running the queries:{color}

 
{code:java}
> show files in az.root.`Dev/2019-06-06/RD0003FF6A3D5A.log`;

returns 1 row showing the file.

> select * from az.root.`Dev/2019-06-06/RD0003FF6A3D5A.log`;Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 16: Object 'Dev/2019-06-06/RD0003FF6A3D5A.log' not found within 'az.root'{code}
 

{color:#d1d2d3}When I reupload the file as a BlockBlob the query returns the correct results.{color}

{color:#d1d2d3}Third party plugins used.{color}
 * [hadoop-azure-2.7.7.jar|https://repo1.maven.org/maven2/org/apache/hadoop/hadoop-azure/2.7.7/hadoop-azure-2.7.7.jar]
 * [azure-storage-8.0.0.jar|https://repo1.maven.org/maven2/com/microsoft/azure/azure-storage/8.0.0/azure-storage-8.0.0.jar]
            Reporter: Benney Au


{color:#d1d2d3}I'm trying to connect drill to Azure Blob Storage and query some subfolders.{color}
{color:#d1d2d3}using drill-1.18.0.{color}
{color:#d1d2d3}I've setup the storage plugin and I get these results when running the queries:{color}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)