- 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 - CONVERT_FROM() Function
The following program shows the query for this function −
Query
0: jdbc:drill:zk = local> Select CONVERT_FROM ('{x:1, y:2}' ,'JSON') AS Convertion from (values(1));
Result
+--------------------+
| Conversion |
+--------------------+
| {"x":1,"y":2} |
+--------------------+
The above query converts varchar data to JSON format. Similarly, you can use other data types to Drill supported data format. For naming columns, you can use the alias method.
apache_drill_sql_operations.htm
Advertisements