Re: generate uuid/ id for table which do not have any primary key

2015-04-20 Thread Vishal Swaroop
Thanks... Yes that is option we will go forward with. On Apr 20, 2015 10:52 AM, "Kaushik" wrote: > Have you tried select as id, name, age ? > > On Thu, Apr 16, 2015 at 3:34 PM, Vishal Swaroop > wrote: > > > Just wondering if there is a way to generate uuid/ id in data-config > > without using c

Re: generate uuid/ id for table which do not have any primary key

2015-04-20 Thread Kaushik
Have you tried select as id, name, age ? On Thu, Apr 16, 2015 at 3:34 PM, Vishal Swaroop wrote: > Just wondering if there is a way to generate uuid/ id in data-config > without using combination of fields in query... > > data-config.xml > > >batchSize="2000" > name="test" > type="Jdbc

Re: generate uuid/ id for table which do not have any primary key

2015-04-16 Thread Vishal Swaroop
Just wondering if there is a way to generate uuid/ id in data-config without using combination of fields in query... data-config.xml On Thu, Apr 16, 2015 at 3:18 PM, Vishal Swaroop wrote: > Thanks Kaushik & Erick.. > > Though I can populate uuid by using combination of fields but need t

Re: generate uuid/ id for table which do not have any primary key

2015-04-16 Thread Vishal Swaroop
Thanks Kaushik & Erick.. Though I can populate uuid by using combination of fields but need to change the type to "string" else it throws "Invalid UUID String" a) I will have ~80 millions records and wondering if performance might be issue b) So, during update I can still use combination of fiel

Re: generate uuid/ id for table which do not have any primary key

2015-04-16 Thread Erick Erickson
This seems relevant: http://stackoverflow.com/questions/16914324/solr-4-missing-required-field-uuid Best, Erick On Thu, Apr 16, 2015 at 11:38 AM, Kaushik wrote: > You seem to have defined the field, but not populating it in the query. Use > a combination of fields to come up with a unique id th

Re: generate uuid/ id for table which do not have any primary key

2015-04-16 Thread Kaushik
You seem to have defined the field, but not populating it in the query. Use a combination of fields to come up with a unique id that can be assigned to uuid. Does that make sense? Kaushik On Thu, Apr 16, 2015 at 2:25 PM, Vishal Swaroop wrote: > How to generate uuid/ id (maybe in data-config.xml

generate uuid/ id for table which do not have any primary key

2015-04-16 Thread Vishal Swaroop
How to generate uuid/ id (maybe in data-config.xml...) for table which do not have any primary key. Scenario : Using DIH I need to import data from database but table does not have any primary key I do have uuid defined in schema.xml and is uuid data-config.xml Error : Document is missi