# How to convert uuid into string in logstash

**URL:** <https://discuss.elastic.co/t/how-to-convert-uuid-into-string-in-logstash/127069>\
**Category:** Logstash\
**Created:** [April 6, 2018, 10:17am UTC](https://discuss.elastic.co/t/how-to-convert-uuid-into-string-in-logstash/127069 "2018-04-06T10:17:57Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![aarthinim](https://avatars.discourse-cdn.com/v4/letter/a/35a633/32.png) [@aarthinim](https://discuss.elastic.co/u/aarthinim)\
**Post date:** [April 6, 2018, 10:17am UTC](https://discuss.elastic.co/t/how-to-convert-uuid-into-string-in-logstash/127069/1 "2018-04-06T10:17:57Z")

</div>

My table structure is  
create table dev.emp (  
empid int,  
emp\_first varchar,  
emp\_last varchar,  
empno uuid primary key,  
);  
Logstash configuration is  
input {

```
	jdbc{
	jdbc_connection_string => "jdbc:cassandra://localhost:9042/dev"
	jdbc_user => "cassandra"
	jdbc_password => "cassandra"
	jdbc_driver_library => "/Users/nfrteam/.DbSchema/drivers/Cassandra/cassandrajdbc1.1.jar"
	jdbc_driver_class => "com.dbschema.CassandraJdbcDriver"
	statement => "SELECT * FROM dev.emp"
	tags => ["jdbc2"]
}

```

output{  
if "jdbc2" in [tags]{  
stdout {  
codec =\> "rubydebug"  
}  
}  
}

I'm getting this error "Exception when executing JDBC query {:exception=\>#\<Sequel::DatabaseError: Java::OrgLogstash::MissingConverterException: Missing Converter handling for full class name=java.util.UUID, simple name=UUID\>}"

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [April 6, 2018, 11:30am UTC](https://discuss.elastic.co/t/how-to-convert-uuid-into-string-in-logstash/127069/2 "2018-04-06T11:30:26Z")

</div>

Update your SQL statement to convert the UUID column into a varchar.

---

<div class="post-metadata">

**Author:** ![aarthinim](https://avatars.discourse-cdn.com/v4/letter/a/35a633/32.png) [@aarthinim](https://discuss.elastic.co/u/aarthinim)\
**Post date:** [April 6, 2018, 11:56am UTC](https://discuss.elastic.co/t/how-to-convert-uuid-into-string-in-logstash/127069/3 "2018-04-06T11:56:34Z")

</div>

But in my table uuid is necessary while using in logstash I m getting error . How to use uuid in logstash ?

---

<div class="post-metadata">

**Author:** ![Jenni](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jenni/32/29684_2.png) [@Jenni](https://discuss.elastic.co/u/Jenni)\
**Post date:** [April 6, 2018, 12:14pm UTC](https://discuss.elastic.co/t/how-to-convert-uuid-into-string-in-logstash/127069/4 "2018-04-06T12:14:31Z")

</div>

He's not asking you to change your database table structure, just the SELECT query for logstash. ('SELECT CAST(empno AS varchar) .... ')

---

<div class="post-metadata">

**Author:** ![aarthinim](https://avatars.discourse-cdn.com/v4/letter/a/35a633/32.png) [@aarthinim](https://discuss.elastic.co/u/aarthinim)\
**Post date:** [April 6, 2018, 12:38pm UTC](https://discuss.elastic.co/t/how-to-convert-uuid-into-string-in-logstash/127069/5 "2018-04-06T12:38:09Z")

</div>

SELECT CAST (empno AS varchar) FROM dev.emp;  
SyntaxException: line 1:19 missing ')' at 'AS' (SELECT CAST (empno [AS] varchar...)  
Its not working .

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 4, 2018, 12:38pm UTC](https://discuss.elastic.co/t/how-to-convert-uuid-into-string-in-logstash/127069/6 "2018-05-04T12:38:12Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.