@Felix Albani Thanks for quick response I need to delete around 100 records , Each one having unique identity number is their any way to delete in a single shot Since below process is taking more time for million of records curl 'http://localhost:8080/solr/<core-name>/update'-H "Content-type: text/xml"--data-binary '<delete><query> dataid : 101</query></delete>' curl 'http://localhost:8080/solr/<core-name>/update'-H "Content-type: text/xml"--data-binary '<delete><query> dataid : 1058262 </query></delete>' curl 'http://localhost:8080/solr/<core-name>/update'-H "Content-type: text/xml"--data-binary '<delete><query> dataid : 74965103</query></delete>' curl 'http://localhost:8080/solr/<core-name>/update'-H "Content-type: text/xml"--data-binary '<delete><query> dataid : 1895604 </query></delete>' curl 'http://localhost:8080/solr/<core-name>/update'-H "Content-type: text/xml"--data-binary '<delete><query> dataid : 1023135</query></delete>' .... .... .... .... curl 'http://localhost:8080/solr/<core-name>/update'-H "Content-type: text/xml"--data-binary '<delete><query> dataid : 18465498</query></delete>' curl 'http://localhost:8080/solr/<core-name>/update'-H "Content-type: text/xml"--data-binary '<delete><query> dataid : 1878999</query></delete>' curl 'http://localhost:8080/solr/<core-name>/update'-H "Content-type: text/xml"--data-binary '<delete><query> dataid : 222100</query></delete>' ... View more

@Shu Please find the Sample data hdfs://Test/lob/ebia/publish/gss_attribute_details_pub/load_dt=20170303 hdfs://eualty/lob/bi/publish/ccdp/v1/pub/gss_attribute_details_pub/load_dt=20170322 hdfs://Test/lob/ebia/source/ebia/ccdp_genesys_fmr_router_core/load_date=2018-04-29 hdfs://eualty/lob/bi/source/ebia/ccdp_genesys_fmr_router_core/load_date=2018-04-30 hdfs://Test/lob/ebia/publish/ebia/interaction_fact_core/load_date=2017-12-16 hdfs://Test/lob/ebia/publish/ccdp/v1/core/interaction_fact_core/load_date=2017-12-21 hdfs://eualty/lob/bi/publish/ccdp/v1/pub/task_event_details_pub/load_date=2018-04-26/historical_intraday_record=I hdfs://Test/lob/bi/publish/pi/v1/pub/task_event_details_pub/load_date=2018-05-22/historical_intraday_record=I hdfs://eualty/lob/ebia/publish/bi/avaya_call_details_pub/year=2018/quarter=1/month=1 hdfs://eualty/lob/bi/publish/ebia/avaya_call_details_pub/year=2017/quarter=4/month=11 hdfs://Test/lob/ebia/project/pi/avaya_call_details_pub/year=2018/quarter=1/month=3 hdfs://Test/lob/bi/project/bi/avaya_call_details_pub/year=2017/quarter=3/month=8 hdfs://eualty/lob/ebia/project/ebia/avaya_call_details_pub/year=2018/quarter=2/month=5 ... View more

@Shu , Thanks for your quick Suggestions Mentioned function is only work if location field is having "rownum=" i had a data without "rownum=" hdfs://servername/sds/sds/erg/tabledata=456/size=123/length=456 hdfs://servername/sds/sds/erg/meta/data/ccdp/hive _table=test/size=123/length=456 hdfs://servername/sds/sds/erg/calims/notes/ccdp/meta/mgnt/work_space=895/rownum=123/columnnumber=456 2.Using forward slashes and extracting method also not working if location fields changes with different data Like this this records many or there with different variables using for partitioning , I need partitioning fields in the another column , Starting '=" fields in the partition columns Can you please help on this ..!!! Thanks in advance...!! ... View more

@Shu Please find the below sample data hdfs://servername/sds/sds/erg/rownum=123/columnnumber=456 hdfs://servername/sds/sds/erg/meta/data/ccdp/rownum=123/columnnumber=456 hdfs://servername/sds/sds/erg/calims/notes/ccdp/meta/mgntrownum=123/columnnumber=456 hdfs://servername/sds/sds/erg/calims/notes/ccdp/meta/mgnt/lo/rownum=123/columnnumber=456 hdfs://servername/sds/sds/erg/calims/notes/ccdp/meta/mgnt/lo/ap/rownum=123/columnnumber=456 Length is getting increasing for location , so how can we convert based on "=" sign Can u please suggest..!!! Thanks in advance..!!! ... View more

@Shu Thanks for Quick response I had total 10 Lakh records like that , with different data and different string length Above mentioned code only satisfying with that one record only I need a generic code for all data , It should satisfy with all records, Can u please suggest..!!! Thanks in advance..!!! ... View more

@Eyad Garelnabi Above DSL Search query is working for creating time only , Its not working for Modified Time Find below query with modified time , Its not working http://localhost:21000/api/atlas/v2/search/dsl?query=modifiedTime%3E'2017-08-02T16%3A33%3A23.408Z'&typeName=hive_table Please help on this..!!! ... View more