Question: You run the following aggregation on a Delta table: df . count ( ) You go to SQL tab and see the following: local table

You run the following aggregation on a Delta table:
df.count()
You go to SQL tab and see the following:
local table scan.png
What does 'Local Table Scan' mean?
Group of answer choices
It didn't have to do a Shuffle/Exchange
It had to read the data files to get local/global count
It was able to cover the query from statistics in Metadata
It pulled data from Delta cache on Worker's local SSD drive

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

Before you do the exercises If you havent already done so, you should create a folder in your personal drive for all the exercises. This set of exercises requires a functioning webserver to interpret...

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

DATABASE MANEGMENT SYSTEMS Lab: Using SQL Developer (Individual Assignment) Objective: Creating/populating tables using SQL commands in SQL Developer Learning how to add referential integrity and...

Q:

DATA STRUCTURE...please help In this question, you will be implementing a hash table with a set of functionalities specified below. As you know, we already covered this topic in class and even...

Q:

Please helpFrom the text- please make one annotation per page Workbook please complete using the text 4 Files 4:01 PM Fri May '13 Insert Draw Layout Review View Unit 4Economic Indicators Name: HR:...

Q:

Liting Wang Shelly Cashman Excel 2013 Chapter 10: SAM Project 1a Submission #2 Score is 79 out of 100 1. Go to the Event Schedule - 2018 worksheet and use the password J@Nuary18 to unprotect the...

Q:

The instructions are attached in the Division Performance Evaluation Division Performance Evaluation Project Using Excel In this assignment you will analyze the performance of PepsiCo or Marriott's...

Q:

1. The manager wants to add the artist Johannes Vermeer as an artist in the database. He was born in 1632 and is from the Netherlands and died in 1674. He is not a local artist. What would the insert...

Q:

1. The manager wants to add the artist Johannes Vermeer as an artist in the database. He was born in 1632 and is from the Netherlands and died in 1674. He is not a local artist. What would the insert...

Q:

Data Structure In this question, you will be implementing a hash table with a set of functionalities specified below. As you know, we already covered this topic in class and even provided an...

Q:

Pro-forma financial statements can raise expectations about a businesss financial performance. If the actual performance does not meet those expectations, there can be negative consequences. Should...

Q:

A biologist is an expert in understanding living organisms and the environments these organisms inhabit. They tend to specialize in one particular area of biology and often work with one type of...

Q:

All of the following are other receivables except: Group of answer choices a . petty cash. b . interest receivable. c . income taxes refundable. d . advances to employees.

Q:

Mahindn manufactures XUV. Currently, the company has a plant in Mangalore and a plant in Hyderabad and it needs to decide where to build a new plant, Erode or Ranchi. Use the transport cost data from