Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Using INDEX inside SUBSTR


+
dyuti a 2013-07-10, 12:06
Copy link to this message
-
Re: Using INDEX inside SUBSTR
rather than us just do the work for you show us your attempts to solve
this.  hint: did you look at this page?

https://cwiki.apache.org/Hive/languagemanual-udf.html#LanguageManualUDF-StringFunctions
On Wed, Jul 10, 2013 at 5:06 AM, dyuti a <[EMAIL PROTECTED]> wrote:

> Hi All,
> One of my Teradata query is
>
> SUBSTR(PRESG_ID,INDEX(PRESG_ID,' ')+1,1) IN  ('1','2','3')
>
> Any idea of the above to convert to hive, It seems to be a simple qus but
> am stuck...didn't get a chance to try it out in cluster :(
>
>
> -Thanks
>
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB