registration-reminder-modal
Learning & Certification
Certifications
Learning Paths
Databricks Product Tours
Get Started Guides
Product Platform Updates
What's New in Databricks
Discussions
Databricks Platform Discussions
Administration & Architecture
Data Engineering
Data Governance
Generative AI
Machine Learning
Warehousing & Analytics
Databricks Free Trial Help
Community Discussions
Certifications
Training offerings
Community Platform Discussions
Get Started Discussions
Summit 2024
Resources
Get Started Resources
Events
Support FAQs
Technical Blog
Knowledge Sharing Hub
Announcements
DatabricksTV
Groups
Regional and Interest Groups
Americas (AMER)
Asia-Pacific & Japan (APJ)
Europe, Middle East, and Africa (EMEA)
Interest Groups
Private Groups
Skills@Scale
Community Cove
Databricks Community Champions
Khoros Community Forums Support (Not for Databricks Product Questions)
Databricks Community Code of Conduct
Register to join the community
Databricks Community
Learning & Certification
Certifications
Learning Paths
Databricks Product Tours
Get Started Guides
Product Platform Updates
What's New in Databricks
Discussions
Databricks Platform Discussions
Administration & Architecture
Data Engineering
Data Governance
Generative AI
Machine Learning
Databricks Platform Discussions
Warehousing & Analytics
Databricks Free Trial Help
Community Discussions
Certifications
Training offerings
Community Platform Discussions
Get Started Discussions
Summit 2024
Resources
Get Started Resources
Events
Support FAQs
Technical Blog
Knowledge Sharing Hub
Announcements
DatabricksTV
Groups
Regional and Interest Groups
Americas (AMER)
Asia-Pacific & Japan (APJ)
Europe, Middle East, and Africa (EMEA)
Interest Groups
Private Groups
Skills@Scale
Community Cove
Databricks Community Champions
Khoros Community Forums Support (Not for Databricks Product Questions)
Databricks Community Code of Conduct
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Help
Login/
Register
Tejas2022
New Contributor II
since
05-27-2024
11-11-2024
0%
Please visit your
Settings Page
to complete your profile.
User Stats
1
Posts
0
Solutions
0
Kudos given
0
Kudos received
View all badges
Databricks Community
About Tejas2022
Options
User Activity
Posts
Replies
No posts to display.
Re: Nested subquery is not supported in the DELETE condition
05-27-2024
@diego_poggioli Can you try selecting a 'year_month_version' column from the view instead of select * DELETE FROM dev.gold.table AS trg WHERE year_month_version IN (select year_month_version FROM v_distinct_year_month_version)