- 11095 Views
- 2 replies
- 1 kudos
Resolved! net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::5.0.1 user lacks privilege or object not found: full questionnaire in statement [SELECT * FROM "full questionnaire" WHERE 1=0]
I have followed the steps given here to parse .accdb files using ucanaccess on Azure Databricks, however, I receive errors.See below my code:# Connection properties conn_properties = {"driver" : "net.ucanaccess.jdbc.UcanaccessDriver"} # Path url = ...
![net.ucanaccess.jdbc.UcanaccessSQLException_ UCAExc___5.0.1 user lacks privilege or object not found_ full questionnaire in statement [SELECT _ FROM "full questionnaire" WHERE 1=0]](/t5/image/serverpage/image-id/1952iDBC96B99046D53B6/image-size/medium?v=v2&px=400)
- 11095 Views
- 2 replies
- 1 kudos
- 1 kudos
@Valeri Nteleah​ please let me know if you need further help on this.Thanks
- 1 kudos
- 5352 Views
- 2 replies
- 3 kudos
User Initiated Cluster Termination, after 1-2 hours cluster goes offline even while working!
Hi,Wanted to ask, I have been experiencing databricks_error = user initiated cluster terminationdatabricks_error_message: timeout while placing nodesand soetimes it stays stuck on "finding new nodes, instances if neccessary" for hours..and it goes of...
- 5352 Views
- 2 replies
- 3 kudos
- 3 kudos
We have identified that the recent deployment done on the backend service on which Azure Data factory relies upon had prevented the data flow activity from running and this had caused the issue But can you confirm @Ghazanfar Uruj​ if the issue persis...
- 3 kudos
- 35243 Views
- 1 replies
- 10 kudos
Resolved! How do temp views actually work?
So I'm querying data from parquet files that have a couple of billions records (table 1 or t1), and then have to filter and then join with other parquet files with another couple of billions records (t2). This takes quite a long time to run (like 10h...
- 35243 Views
- 1 replies
- 10 kudos
- 10 kudos
Your intuition about views is correct. Views are not materialized, so they are basically just a saved query. Every time you access a view it will have to be recomputed. This is certainly not ideal if it take a long time (like 10hrs) to materialize a ...
- 10 kudos
- 7114 Views
- 3 replies
- 4 kudos
Resolved! VNET injected Databricks cluster not able to mount - 403 error
I'm mounting a Storage Account to a Databricks cluster in Azure. All the resources are included in a VNET and a private and public subnet has been associated to the Databricks resource. Below I've attached the guide we use for mounting the ADLS G2 to...
- 7114 Views
- 3 replies
- 4 kudos
- 4 kudos
Hey there @Derrick Bakhuis​ Hope you are well. Just wanted to see if you were able to find an answer to your question and would you like to mark an answer as best? It would be really helpful for the other members too.Cheers!
- 4 kudos
- 2317 Views
- 0 replies
- 0 kudos
GCP Databricks Cluster Start issue - Free trail Account
I have GCP trial account and took a 14 days databricks free trial from GCP. I created workspace and trying to create cluster and start it but it keeps on rotating/pending state. As a initial step, I tried to increase quotas mentioned on the page but ...
- 2317 Views
- 0 replies
- 0 kudos
- 2942 Views
- 0 replies
- 0 kudos
Recommended Redshift-2-Delta Migration Path
Hello All!My team is previewing Databricks and are contemplating the steps to take to perform one-time migrations of datasets from Redshift to Delta. Based on our understandings of the tool, here are our initial thoughts:Export data from Redshift-2-S...
- 2942 Views
- 0 replies
- 0 kudos
- 12674 Views
- 1 replies
- 2 kudos
"Detected a data update", what changed?
In streaming flows I periodically get a "Detected a data update" error. This error generally seem to indicate that something has changed in the source table schema, but it's not immediately apparent what. In one case yesterday I pulled the source tab...
- 12674 Views
- 1 replies
- 2 kudos
- 2 kudos
@Kaniz Fatma​ , Thanks, that helps. I was assuming this warning indicated a schema evolution, and based on what you say it likely wasn't and I just have to turn on IgnoreChanges any time I have a stream from a table that receives updates/upserts.To b...
- 2 kudos
- 1969 Views
- 1 replies
- 2 kudos
Unable to create account in Databricks community Edition
Unable to login to the community edition as the verification email is not delivered.
- 1969 Views
- 1 replies
- 2 kudos
- 2 kudos
Hi sraj, facing same issue. Is your issue resolved. Please guide me also. That will be of great help.
- 2 kudos
- 6158 Views
- 2 replies
- 2 kudos
Mult task - restart of the failed jobs
Hi Team I am using Multitask and I am trying to restart only the failed task but seems like I have to restart complete workflow again and again , is there any way or workaround
- 6158 Views
- 2 replies
- 2 kudos
- 2 kudos
One way that works is to go to your task definition, click advanced options, and set retry policy. The task will restart per those instructions. Does that work for you?
- 2 kudos
- 12410 Views
- 3 replies
- 0 kudos
Specifying a Managed Resource Group name
Azure Databricks provisions a Managed Resource Group when you create your Workspace. Is there a way to specify the name of the Managed Resource Group and its resources during creation?The defaults created by the Workspace violate my company's standar...
- 12410 Views
- 3 replies
- 0 kudos
- 0 kudos
Hey there @Robert Biddle​ Hope you are well. Just wanted to see if you were able to find an answer to your question and would you like to mark an answer as best? It would be really helpful for the other members too.Cheers!
- 0 kudos
- 8213 Views
- 3 replies
- 3 kudos
Resolved! Dealing with updates to a delta table being used as a streaming source
Hi AllI have a requirement to perform updates on a delta table that is the source for a streaming query.I would like to be able to update the table and have the stream continue to work while also not ending up with duplicates.From my research it se...
- 8213 Views
- 3 replies
- 3 kudos
- 3 kudos
Hey @Mathew Walters​ Hope you are doing great.Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution? Else please let us know if you need more help. We'd love to hear from you.Thanks!
- 3 kudos
- 10555 Views
- 4 replies
- 0 kudos
Resolved! ValueError: numpy.ndarray size changed, may indicate binary incompatibility. Expected 88 from C header, got 80 from PyObject
After the new release of numpy 1.22.0 on Dec 31st, Databricks failed with this error for my existing Databricks Notebook Version 10.1 and numpy 1.20.0Qn: Why did the earlier releases after 1.20.0 uptil 1.22.0 did not raise the same exception. ?
- 10555 Views
- 4 replies
- 0 kudos
- 0 kudos
Hi @Janani Mohan​ Hope you are doing well.Just wanted to check in if you were able to resolve your issue or do you need more help? We'd love to hear from you.Thanks!
- 0 kudos
- 8272 Views
- 9 replies
- 1 kudos
Resolved! Migrating DB from 7.3 LTS to 9.1 LTS
Hi All,I have a code in the dev and production using DB 7.3 LTS. Now, I would like to update the environment to 9.1 LTS as support is going to finish. I have gone through the documentation given in the following link. https://docs.databricks.com/rele...
- 8272 Views
- 9 replies
- 1 kudos
- 1 kudos
@Kiran Chalasani​ Hey Have you ever been able to run 7.3run time with multi_gpus before you migrated to 9.1?
- 1 kudos
- 4827 Views
- 1 replies
- 1 kudos
Databricks dashboard removing order, incorrectly sorted.
I created a table that aggregates data by year and week of year and display this in a chart over time. As part of the query, I order by the year, then week columns. In the visualization on the query (in the SQL editor), I disabled the sort, because i...
- 4827 Views
- 1 replies
- 1 kudos
- 1 kudos
Hi @Mr. E (Customer)​ , did you get a chance to check Kaniz's previous comments ? is this issue resolved or do you need any further help here ?
- 1 kudos
- 8528 Views
- 7 replies
- 10 kudos
Resolved! Delta Upsert performance on empty table
Hello all,I was just wandering, performance wise how does it compare a plain write operation with a merge operation on an EMPTY delta table. Do we really risk to get significant performance drop?The use case would be to have the same pipeline for ini...
- 8528 Views
- 7 replies
- 10 kudos
- 10 kudos
Hello @Kaniz Fatma​ ,Unfortunately I did not do any further investigation on the subject. Given that the merge on an empty table will only be done once at the creation of a table, it wouldn't really matter to be honest.
- 10 kudos
| User | Count |
|---|---|
| 1645 | |
| 793 | |
| 584 | |
| 349 | |
| 287 |
