# Describe Stream; command not showing rowkey and rowtime **URL:** \ **Category:** ksqlDB\ **Created:** [16 June 2021 04:48 UTC](https://forum.confluent.io/t/describe-stream-command-not-showing-rowkey-and-rowtime/2044 "2021-06-16T04:48:50Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![shubhamshirur](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@shubhamshirur](https://forum.confluent.io/u/shubhamshirur)\ **Post date:** [16 June 2021 04:48 UTC](https://forum.confluent.io/t/describe-stream-command-not-showing-rowkey-and-rowtime/2044/1 "2021-06-16T04:48:53Z")
I am trying to create a stream over kafka topic. When I am doing describe against stream it is showing just column names & I am unable to fetch data either. Showing empty table with just column index names. Please help regarding this. ---
**Author:** ![mjsax](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/mjsax/32/3113_2.png) [@mjsax](https://forum.confluent.io/u/mjsax)\ **Post date:** [16 June 2021 04:53 UTC](https://forum.confluent.io/t/describe-stream-command-not-showing-rowkey-and-rowtime/2044/2 "2021-06-16T04:53:52Z")
`ROWKEY` and `ROWTIME` as implicit columns and thus are excluded from `DESCRIBE`. There is also `DESCRIBE EXTENDED` that provides more information though: [DESCRIBE - ksqlDB Documentation](https://docs.ksqldb.io/en/latest/developer-guide/ksqldb-reference/describe/) It would help if you post the commands you issued, and the output you get, and describe in more detail what output you expect. Note that `DESCRIBE` show metadata and it does not show records. If you want to get actual data, you need to issue a query. > Showing empty table with just column index names. Not sure what you mean by this. ---
**Author:** ![shubhamshirur](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@shubhamshirur](https://forum.confluent.io/u/shubhamshirur)\ **Post date:** [16 June 2021 05:25 UTC](https://forum.confluent.io/t/describe-stream-command-not-showing-rowkey-and-rowtime/2044/3 "2021-06-16T05:25:16Z")
Case Study : To segregate data records a topic to two different topics according to the value of one of columns. Example: topic name - fruits Data in topic - JSON {“fruit”:“apple”, “color”:“red”} {“fruit”:“mango”, “color”:'“yellow”} and so on. I want to filter these records on color i.e records from topic fruits should with color red should enter into redfruits topic and with yellow color in yellowfruits topic. But when I am creating stream with this topic and value format JSON. Stream is created but no data is shown after throwing select query with emit changes. I have done auto offset reset to earliest still no effect . In kafka logs I’m frequently seeing this log message after throwing select query with emit changes: ```auto [2021-06-16 05:24:23,755] INFO stream-client [_confluent-ksql-default_transient_7238284644999143506_1623821063655-e15ceb24-3774-426c-b6c2-d3f5e3047aa5] State transition from CREATED to REBALANCING (org.apache.kafka.streams.KafkaStreams:281) [2021-06-16 05:24:23,755] INFO stream-thread [_confluent-ksql-default_transient_7238284644999143506_1623821063655-e15ceb24-3774-426c-b6c2-d3f5e3047aa5-StreamThread-1] Starting (org.apache.kafka.streams.processor.internals.StreamThread:516) [2021-06-16 05:24:23,755] INFO stream-thread [_confluent-ksql-default_transient_7238284644999143506_1623821063655-e15ceb24-3774-426c-b6c2-d3f5e3047aa5-StreamThread-2] Starting (org.apache.kafka.streams.processor.internals.StreamThread:516) [2021-06-16 05:24:23,757] INFO stream-thread [_confluent-ksql-default_transient_7238284644999143506_1623821063655-e15ceb24-3774-426c-b6c2-d3f5e3047aa5-StreamThread-1] State transition from CREATED to STARTING (org.apache.kafka.streams.processor.internals.StreamThread:225) [2021-06-16 05:24:23,757] INFO stream-thread [_confluent-ksql-default_transient_7238284644999143506_1623821063655-e15ceb24-3774-426c-b6c2-d3f5e3047aa5-StreamThread-2] State transition from CREATED to STARTING (org.apache.kafka.streams.processor.internals.StreamThread:225) [2021-06-16 05:24:23,757] INFO stream-thread [_confluent-ksql-default_transient_7238284644999143506_1623821063655-e15ceb24-3774-426c-b6c2-d3f5e3047aa5-StreamThread-3] Starting (org.apache.kafka.streams.processor.internals.StreamThread:516) [2021-06-16 05:24:23,757] INFO stream-thread [_confluent-ksql-default_transient_7238284644999143506_1623821063655-e15ceb24-3774-426c-b6c2-d3f5e3047aa5-StreamThread-3] State transition from CREATED to STARTING (org.apache.kafka.streams.processor.internals.StreamThread:225) [2021-06-16 05:24:23,757] INFO Streaming query 'select * from jsondata emit changes;' (io.confluent.ksql.rest.server.resources.streaming.StreamedQueryResource:314) [2021-06-16 05:24:23,757] INFO stream-thread [_confluent-ksql-default_transient_7238284644999143506_1623821063655-e15ceb24-3774-426c-b6c2-d3f5e3047aa5-StreamThread-4] Starting (org.apache.kafka.streams.processor.internals.StreamThread:516) [2021-06-16 05:24:23,757] INFO stream-thread [_confluent-ksql-default_transient_7238284644999143506_1623821063655-e15ceb24-3774-426c-b6c2-d3f5e3047aa5-StreamThread-4] State transition from CREATED to STARTING (org.apache.kafka.streams.processor.internals.StreamThread:225) [2021-06-16 05:24:23,859] INFO stream-thread [_confluent-ksql-default_transient_7238284644999143506_1623821063655-e15ceb24-3774-426c-b6c2-d3f5e3047aa5-StreamThread-1] Processed 0 total records, ran 0 punctuators, and committed 0 total tasks since the last update (org.apache.kafka.streams.processor.internals.StreamThread:732) [2021-06-16 05:24:23,863] INFO stream-thread [_confluent-ksql-default_transient_7238284644999143506_1623821063655-e15ceb24-3774-426c-b6c2-d3f5e3047aa5-StreamThread-4] Processed 0 total records, ran 0 punctuators, and committed 0 total tasks since the last update (org.apache.kafka.streams.processor.internals.StreamThread:732) [2021-06-16 05:24:23,864] INFO stream-thread [_confluent-ksql-default_transient_7238284644999143506_1623821063655-e15ceb24-3774-426c-b6c2-d3f5e3047aa5-StreamThread-2] Processed 0 total records, ran 0 punctuators, and committed 0 total tasks since the last update (org.apache.kafka.streams.processor.internals.StreamThread:732) [2021-06-16 05:24:23,864] INFO stream-thread [_confluent-ksql-default_transient_7238284644999143506_1623821063655-e15ceb24-3774-426c-b6c2-d3f5e3047aa5-StreamThread-3] Processed 0 total records, ran 0 punctuators, and committed 0 total tasks since the last update (org.apache.kafka.streams.processor.internals.StreamThread:732) [2021-06-16 05:24:49,461] INFO Retrying request. Retry no: 1 Cause: 'org.apache.kafka.common.errors.TimeoutException: Call(callName=findCoordinator, deadlineMs=1623821089460, tries=596, nextAllowedTryMs=1623821089561) timed out at 1623821089461 after 596 attempt(s)' (io.confluent.ksql.util.ExecutorUtil:95) ``` @mjsax Can you help? ---
**Author:** ![mjsax](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/mjsax/32/3113_2.png) [@mjsax](https://forum.confluent.io/u/mjsax)\ **Post date:** [16 June 2021 20:47 UTC](https://forum.confluent.io/t/describe-stream-command-not-showing-rowkey-and-rowtime/2044/4 "2021-06-16T20:47:32Z")
Can you share the `CREATE STREAM` command and the query you issue? Also, the command to change `auto.offset.set` (it must use quotes to be correct…) The log you show are only INFO logs… ---
**Author:** ![system](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/1X/c49438c90c9df282e9996fdf6971be890c71b65a.svg) [@system](https://forum.confluent.io/u/system)\ **Post date:** [16 July 2021 04:48 UTC](https://forum.confluent.io/t/describe-stream-command-not-showing-rowkey-and-rowtime/2044/5 "2021-07-16T04:48:55Z")
This topic was automatically closed after 30 days. New replies are no longer allowed.