You have an Azure Synapse workspace named MyWorkspace that contains an Apache Spark database named mytestdb.
You run the following command in an Azure Synapse Analytics Spark pool in MyWorkspace.
CREATE TABLE mytestdb.myParquetTable(
EmployeeID int,
EmployeeName string,
EmployeeStartDate date)
USING Parquet -
You then use Spark to insert a row into mytestdb.myParquetTable. The row contains the following data.
One minute later, you execute the following query from a serverless SQL pool in MyWorkspace.
SELECT EmployeeID -
FROM mytestdb.dbo.myParquetTable
WHERE EmployeeName = 'Alice';
What will be returned by the query?
gerrie1979
Highly Voted 2 years, 4 months agocecbc1f
1 year agomaximilianogarcia6
2 years, 4 months agoyogiazaad
2 years, 1 month agoVirul
2 years, 1 month agodmitriypo
Highly Voted 2 years, 4 months agopsicktrick
2 years, 2 months agoBedmed
6 months, 2 weeks agock8.kakade
7 months, 3 weeks agogoldy29
1 year, 8 months agodevnginx
1 year, 3 months agoShaik_Shahul
1 year, 5 months ago__Tom
11 months, 2 weeks agoSenMia
1 year, 3 months agoAMJB
Most Recent 4 days, 8 hours agoLethahavm
5 days, 4 hours agoCiske92
1 month, 1 week agoRayenwalid
1 month, 3 weeks agoRomanx
2 months agoAsheesh1909
2 months, 2 weeks agoabhi_11kr1
3 months, 2 weeks agohypersam
2 months, 1 week ago19a3424
3 months, 3 weeks agoEmnCours
3 months, 3 weeks agoAnithec0der
3 months, 3 weeks agoBrilliantBeast
4 months agoexamdemo
5 months, 2 weeks agoesaade
5 months, 3 weeks agomilad2021
5 months, 3 weeks agoAlejandroU
1 year, 5 months agoKatiane
5 months, 3 weeks ago