Also, there is a logging feature to print intermediate values. Another point is the complexity of your query. It can be easier to test with the query as a database view, instead of embedding it in the DIH script.
On Fri, Aug 24, 2012 at 9:00 AM, Ahmet Arslan <iori...@yahoo.com> wrote: > >> That is not completely true. If the columns have the same >> names as the fields, the mapping is redundant. Nevertheless, >> it might be the problem. What I've experienced with Oracle, >> at least, is that the columns would be returned in uppercase >> even if my alias would be in lowercase. You might force it >> by adding quotes, though. Or try adding >> >> <field name="location" column="LOCATION" /> >> <field name="amount" column="AMOUNT" /> >> <field name="when" column="WHEN" /> >> >> You might check in your preferred SQL client how the column >> names are returned. It might be an indicator. (At least, in >> my case they would be uppercase in SQL Developer.) > > There is a jsp page for debugging DIH > > http://localhost:8080/solr/admin/dataimport.jsp?handler=/dataimport -- Lance Norskog goks...@gmail.com
