- Apache Drill Tutorial
- Apache Drill - Home
- Apache Drill - Introduction
- Apache Drill - Fundamentals
- Apache Drill - Architecture
- Apache Drill - Installation
- Apache Drill - SQL Operations
- Apache Drill - Query using JSON
- Window Functions using JSON
- Querying Complex Data
- Data Definition Statements
- Apache Drill - Querying Data
- Querying Data using HBase
- Querying Data using Hive
- Apache Drill - Querying Parquet Files
- Apache Drill - JDBC Interface
- Apache Drill - Custom Function
- Apache Drill - Contributors
- Apache Drill Useful Resources
- Apache Drill - Quick Guide
- Apache Drill - Useful Resources
- Apache Drill - Discussion
Apache Drill - SQL Operator LIKE
The Like Operator is used for pattern matching.
The following program shows the query for this function −
Query
0: jdbc:drill:zk = local> select name from dfs.`/Users/../workspace/Drill-samples/student_list.json` where name like ‘A%';
Result
name Adam Amit
The above query returns this result, when the name first letter is starting with ‘A’.
apache_drill_query_using_json.htm
Advertisements