Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Connect to azure datalake gen2 #313

Open
fermff opened this issue Dec 27, 2023 · 2 comments
Open

Connect to azure datalake gen2 #313

fermff opened this issue Dec 27, 2023 · 2 comments

Comments

@fermff
Copy link

fermff commented Dec 27, 2023

I'm trying to connect to Azure Datalake Gen2. I read in doc that abfss scheme is supported. However, it fails. Is there something I'm missing?

Configuration

Environment Variables

AZURE_STORAGE_ACCOUNT_NAME=xxxxxxstadatalake
AZURE_STORAGE_CLIENT_ID=xxxxxxxxxxxxxxxx
AZURE_STORAGE_CLIENT_SECRET=xxxxxxxxxxxxxxxxxxx
AZURE_STORAGE_TENANT_ID=xxxxxxxxx

YAML

tables:

  • name: mytable
    uri: abfss://mycontainer/mg/cli/profile/mytable
    option:
    format: delta

Error Message

Failed to create Roapi context: Whatever { source: Some(TableError { source: Io { source: InvalidUriScheme { scheme: "abfss" } } }), message: "Failed to load table", backtrace: Backtrace(()) }

@fermff
Copy link
Author

fermff commented Dec 27, 2023

It seems to me that abfss is not supported? Line 56 of columnq.src.io.mod.rs

image

@fermff
Copy link
Author

fermff commented Dec 28, 2023

I've been digging a bit around. If I add abfss to the list of possible azure types it works, but only if we don't load table into memory.

If I try to load a table into memory I get an error because deltable schema does not match rowbatch schema (the difference is in the nullable attribute of some fields... being correct the ones considered inside RowBatch).

Is there any possibility to specify nullable values in the configuration Yaml?

Cheers

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant