# I'm looking forward to test out similarity search on pinecone.

**URL:** <https://community.pinecone.io/t/im-looking-forward-to-test-out-similarity-search-on-pinecone/509>\
**Category:** Support\
**Tags:** semantic-search, vector-database\
**Created:** [November 28, 2022, 2:01pm UTC](https://community.pinecone.io/t/im-looking-forward-to-test-out-similarity-search-on-pinecone/509 "2022-11-28T14:01:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jdranpariya](https://avatars.discourse-cdn.com/v4/letter/j/8baadc/32.png) [@jdranpariya](https://community.pinecone.io/u/jdranpariya)\
**Post date:** [November 28, 2022, 2:01pm UTC](https://community.pinecone.io/t/im-looking-forward-to-test-out-similarity-search-on-pinecone/509/1 "2022-11-28T14:01:55Z")

</div>

I would like to know more about how can I Import sql table column/ spark DataFrame column as input and which further I want to vectorize it(only way I know of now is tf-idf let me know if you know how to do word embeddings at 2 or 3 grams level). And than get the closest match for the query I perform.

Regards,  
Jaydeep

---

<div class="post-metadata">

**Author:** ![kbutler](https://avatars.discourse-cdn.com/v4/letter/k/ed655f/32.png) [@kbutler](https://community.pinecone.io/u/kbutler)\
**Post date:** [November 28, 2022, 4:45pm UTC](https://community.pinecone.io/t/im-looking-forward-to-test-out-similarity-search-on-pinecone/509/2 "2022-11-28T16:45:10Z")

</div>

Hello jdranpariya, welcome to the community. Here is a specific example that works with pandas dataframes and imports flat file data. [https://www.pinecone.io/docs/examples/semantic-text-search/](https://www.pinecone.io/docs/examples/semantic-text-search/)  
There are many ways to process data and create embeddings. There are even third party services that can help you do this such as [Cohere.ai](https://cohere.ai/) and [HuggingFace](https://huggingface.co/). Best of luck and let us know how it goes!
