Cmdlets for Spark SQL

Build 24.0.9060

Select-SparkSQL Cmdlet

Parameters   Output Objects  

Searches Spark SQL data.

Syntax

Select-SparkSQL [parameters]

Remarks

The Select-SparkSQL cmdlet allows you to use a syntax similar to SQL SELECT statements to search Spark SQL data.

$conn = Connect-SparkSQL -Server '127.0.0.1'
Select-SparkSQL -Connection $conn -Table "Customers" -Columns @("City","CompanyName") -Where "Country='US'"

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060