You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Nick Stenroos-Dam (Jira)" <ji...@apache.org> on 2021/05/31 09:16:00 UTC
[jira] [Commented] (DRILL-7897) Cannot query PageBlobs from Azure
Blob Storage V2
[ https://issues.apache.org/jira/browse/DRILL-7897?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17354330#comment-17354330 ]
Nick Stenroos-Dam commented on DRILL-7897:
------------------------------------------
The documentation for the [Hadoop drive|https://hadoop.apache.org/docs/current/hadoop-azure/index.html#Page_Blob_Support_and_Configuration] writes:
{quote}page blobs are only tested in context of HBase write-ahead logs.
{quote}
> 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
> Priority: Minor
> Labels: AZURE
>
> {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/server.csv`;
> returns 1 row showing the file
> > select * from az.root.`Dev/2019-06-06/server.csv`;
> 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}
> When I reupload the file as block blob it shows the correct results.
>
> {color:#d1d2d3}third party libraries 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]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)