Thanks... Yes that is option we will go forward with. On Apr 20, 2015 10:52 AM, "Kaushik" <kaushika...@gmail.com> wrote:
> Have you tried select <concatenated fields> as id, name, age ? > > On Thu, Apr 16, 2015 at 3:34 PM, Vishal Swaroop <vishal....@gmail.com> > 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 > > <?xml version="1.0" encoding="UTF-8" ?> > > <dataConfig> > > <dataSource > > batchSize="2000" > > name="test" > > type="JdbcDataSource" > > driver="oracle.jdbc.OracleDriver" > > url="jdbc:oracle:thin:@ldap:...." > > user="myUser" > > password="pwd"/> > > <document> > > <entity name="test_entity" > > docRoot="true" > > dataSource="test" > > query="select name, age from test_user"> > > </entity> > > </document> > > </dataConfig> > > > > On Thu, Apr 16, 2015 at 3:18 PM, Vishal Swaroop <vishal....@gmail.com> > > wrote: > > > > > 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" > > > <field name="uuid" type="string" indexed="true" stored="true" > > > required="true" multiValued="false"/> > > > > > > a) I will have ~80 millions records and wondering if performance might > be > > > issue > > > b) So, during update I can still use combination of fields i.e. uuid ? > > > > > > On Thu, Apr 16, 2015 at 2:44 PM, Erick Erickson < > erickerick...@gmail.com > > > > > > wrote: > > > > > >> 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 <kaushika...@gmail.com> > > 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 that can be > > >> assigned to > > >> > uuid. Does that make sense? > > >> > > > >> > Kaushik > > >> > > > >> > On Thu, Apr 16, 2015 at 2:25 PM, Vishal Swaroop < > vishal....@gmail.com > > > > > >> > wrote: > > >> > > > >> >> 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 > > >> >> <field name="uuid" type="uuid" indexed="true" stored="true" > > >> required="true" > > >> >> multiValued="false"/> > > >> >> <uniqueKey>uuid</uniqueKey> > > >> >> > > >> >> data-config.xml > > >> >> <?xml version="1.0" encoding="UTF-8" ?> > > >> >> <dataConfig> > > >> >> <dataSource > > >> >> batchSize="2000" > > >> >> name="test" > > >> >> type="JdbcDataSource" > > >> >> driver="oracle.jdbc.OracleDriver" > > >> >> url="jdbc:oracle:thin:@ldap:...." > > >> >> user="myUser" > > >> >> password="pwd"/> > > >> >> <document> > > >> >> <entity name="test_entity" > > >> >> docRoot="true" > > >> >> dataSource="test" > > >> >> query="select name, age from test_user"> > > >> >> </entity> > > >> >> </document> > > >> >> </dataConfig> > > >> >> > > >> >> Error : Document is missing mandatory uniqueKey field: uuid > > >> >> > > >> > > > > > > > > >
