As discussed on https://groups.google.com/forum/#!msg/kylo-community/kbCIyRjUCCo/b9FPUi1IDAAJ
Bhaskar - This is a known limitation with Solr. The metadata is indexed, but it is kept outside the Solr instance and hence not available for search. For now, you can still search on the table schemas and ingested data. We plan to look into this in the future.
Alternatively, consider using Elasticsearch which fully supports metadata search.
Couldn't find an issue that tracks this - feel free to close if it's a duplicate.
Would be great to add complete Solr support.