[DRILL-1851] Need some samples for RANK(), ROW_NUMBER(), SubQuery in SELECTStatement - Apache Drill

• Type: New Feature
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 0.6.0
• Fix Version/s: Future
• Component/s: Functions - Drill

Environment

Drill SQL

• Assignee: Unassigned
• Reporter: Chandru
• Created: 12/Dec/14 10:07
• Updated: 28/Oct/15 11:42

Description

Provide some sample queries for the below scenarios,

1.RANK( ) function
rank() over (ORDER BY columns[0] DESC) as rowcount

2. ROW_NUMBER( ) function

row_number() over (PARTITION BY columns[0] ORDER BY columns[1] DESC) as rowcount

3. SubQuery in Select Statement.

SELECT paccnt.R_NAME,
CAST((SELECT N_NATIONKEY FROM dfs.`/home/user/drill/drill-0.6.0/sample-data/nation.parquet`) AS CHAR) AS NUMB
from dfs.`/home/user/drill/drill-0.6.0/sample-data/region.parquet` as paccnt;

Sub-Tasks

• Fragment table in drill: Open