You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Yash Sharma (JIRA)" <ji...@apache.org> on 2014/05/04 12:40:16 UTC
[jira] [Commented] (DRILL-630) Improve substr function by adding :
substr(expression, start)
[ https://issues.apache.org/jira/browse/DRILL-630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13988956#comment-13988956 ]
Yash Sharma commented on DRILL-630:
-----------------------------------
bq.
0: jdbc:drill:zk=local> SELECT employee_id, first_name, substring(first_name, 3) sub_str FROM cp.`employee.json` limit 20;
+-------------+------------+------------+
| employee_id | first_name | sub_str |
+-------------+------------+------------+
| 1 | Sheri | eri |
| 2 | Derrick | rrick |
| 4 | Michael | chael |
| 5 | Maya | ya |
| 6 | Roberta | berta |
| 7 | Rebecca | becca |
| 8 | Kim | m |
| 9 | Brenda | enda |
| 10 | Darren | rren |
| 11 | Jonathan | nathan |
| 12 | Jewel | wel |
| 13 | Peggy | ggy |
| 14 | Bryan | yan |
| 15 | Walter | lter |
| 16 | Peggy | ggy |
| 17 | Brenda | enda |
| 18 | Daniel | niel |
| 19 | Dianne | anne |
| 20 | Beverly | verly |
| 21 | Pedro | dro |
+-------------+------------+------------+
20 rows selected (0.109 seconds)
> Improve substr function by adding : substr(expression, start)
> -------------------------------------------------------------
>
> Key: DRILL-630
> URL: https://issues.apache.org/jira/browse/DRILL-630
> Project: Apache Drill
> Issue Type: Improvement
> Affects Versions: 1.0.0-milestone-1
> Reporter: Yash Sharma
>
> Adding substr(expression, start) to improve string substring function
--
This message was sent by Atlassian JIRA
(v6.2#6252)