Re: Re: [2] SQL Update

Re: [2] SQL Update

On 3/8/07, Debra <[EMAIL PROTECTED]> wrote: I could create a list of field name + type, but doing so I might as well create it and add it to fields in schema.xml. <> Alternative solution: write a SQL schema <-> Solr schema mapper. Should be relatively simple, as long as you are confining yours

Re: [2] SQL Update

: I could create a list of field name + type, but doing so I might as well : create it and add it to fields in schema.xml. that was my original point: if you want to be able to refer to a field as "username" and have it be string, just define it explicitly. : Does solr reread the schema file whe

Re: [2] SQL Update

to user_string:42 and not > user_int:42 ? > > > > -Hoss > > > -- View this message in context: http://www.nabble.com/SQL-Update-tf3358303.html#a9372391 Sent from the Solr - User mailing list archive at Nabble.com.

Re: [2] SQL Update

: I wanted to add data from relational database tables. : To avoid defining each and every table column name in the schema, I thought : I'll append a suffix to the field name depending on it's type. which is fine and dandy for when you index the data, mapping your "string" database column "user",

Re: [2] SQL Update

If you want people do be able to refer to the field "user" and you want it > to be an integer field, why not definie it as an explicit field instead of > a dynamic field? > > > > -Hoss > > > -- View this message in context: http://www.nabble.com/SQL-Update-tf3358303.html#a9362953 Sent from the Solr - User mailing list archive at Nabble.com.

Re: [2] SQL Update

: It would be useful to have a solr setting for stripping the dynamic field : suffix/prefix on index field name to get back the original field name. Does : it make sense? sorry, i'm really not following this talk of "stripping" the dynamic field name to get back the "original" field name ... what

Re: [2] SQL Update

ou use SELECT * > FROM, your tables will need the same names, if you use: SELECT > mysqlfield as mysolrfieldname FROM ... you don't. > > ryan > > > On 3/6/07, Debra <[EMAIL PROTECTED]> wrote: >> >> What is the status of the SQL update? >> Shoul

Re: SQL Update

On 3/6/07, Debra <[EMAIL PROTECTED]> wrote: What is the status of the SQL update? Should all database fields used in sql updates be added to schema.xml before running the sql update? -- View this message in context: http://www.nabble.com/SQL-Update-tf3358303.html#a9341018 Sent from the

SQL Update

What is the status of the SQL update? Should all database fields used in sql updates be added to schema.xml before running the sql update? -- View this message in context: http://www.nabble.com/SQL-Update-tf3358303.html#a9341018 Sent from the Solr - User mailing list archive at Nabble.com.