cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

HowardZ
by New Contributor
  • 1703 Views
  • 2 replies
  • 0 kudos

Resolved! How do I create an athena table (instead of hive table) in databricks?

My dashboard uses Athena as data source for its availability (I don't need to fire up the cluster and manually refresh the data), but it requires me to create the tables manually. Wondering if there is a similar method like the .saveAsTable() to crea...

  • 1703 Views
  • 2 replies
  • 0 kudos
Latest Reply
Kaniz_Fatma
Community Manager
  • 0 kudos

Hi @Howard Zhang​, Here's a fantastic article for your use case. Please have a read.

  • 0 kudos
1 More Replies
User16826994223
by Honored Contributor III
  • 1106 Views
  • 1 replies
  • 0 kudos

MSCK REPAIR TABLE doesn't work in delta

I have a delta table in adls and for the same table, I have defined an external table in hive After creating the hive table and generating manifests, I am loading the partitions using MSCK REPAIR TABLE. All the partition columns are in same But s...

  • 1106 Views
  • 1 replies
  • 0 kudos
Latest Reply
User16826994223
Honored Contributor III
  • 0 kudos

Can you please check partition column order, does it in same sequence as before or it has changed

  • 0 kudos
Srikanth_Gupta_
by Valued Contributor
  • 1079 Views
  • 1 replies
  • 0 kudos
  • 1079 Views
  • 1 replies
  • 0 kudos
Latest Reply
Srikanth_Gupta_
Valued Contributor
  • 0 kudos

Presto and Athena support reading from external tables using a manifest file, which is a text file containing the list of data files to read for querying a tablethis doc explains how to generate Manifest file.https://docs.databricks.com/delta/presto-...

  • 0 kudos
Labels