Hi Pritesh, This list is for development related discussions. Please post this on solr-user.
On Fri, Mar 7, 2014 at 1:21 AM, Pritesh Patel <[email protected]> wrote: > I'm using the dataimporthandler to index data from a mysql DB. Been running > it just fine. I've been using full-imports. I'm now trying implement the > delta import functionality. > > To implement the delta query, you need to be reading the last_index_time > from a properties file to know what new to index. So I'm using the > parameter: > {dataimporter.last_index_time} within my query. > > The problem is when I use this, the date always is : "Thu Jan 01 00:00:00 > UTC 1970". It's never actually reading the correct date stored in the > dataimport.properties file. > > So my delta query does not work. Has anybody see this issue? > > Seems like its always using the beginning date for epoch or unix timestamp > code 0. > > --Pritesh > > P.S. If you want to see the delta query, see below. > > deltaQuery="SELECT node.nid from node where node.type = 'news' and > node.status = 1 and (node.changed > > UNIX_TIMESTAMP('${dataimporter.last_index_time}'jgkg) or node.created > > UNIX_TIMESTAMP('${dataimporter.last_index_time}'))" > > deltaImportQuery="SELECT node.nid, node.vid, node.type, node.language, > node.title, node.uid, node.status, > FROM_UNIXTIME(node.created,'%Y-%m-%dT%TZ') as created, > FROM_UNIXTIME(node.changed,'%Y-%m-%dT%TZ') as changed, node.comment, > node.promote, node.moderate, node.sticky, node.tnid, node.translate, > content_type_news.field_image_credit_value, > content_type_news.field_image_caption_value, > content_type_news.field_subhead_value, content_type_news.field_author_value, > content_type_news.field_dateline_value, > content_type_news.field_article_image_fid, > content_type_news.field_article_image_list, > content_type_news.field_article_image_data, > content_type_news.field_news_blurb_value, > content_type_news.field_news_blurb_format, > content_type_news.field_news_syndicate_value, > content_type_news.field_news_video_reference_nid, > content_type_news.field_news_inline_location_value, > content_type_news.field_article_contributor_nid, > content_type_news.field_news_title_value, page_title.page_title FROM node > LEFT JOIN content_type_news ON node.nid = content_type_news.nid LEFT JOIN > page_title ON node.nid = page_title.id where node.type = 'news' and > node.status = 1 and node.nid = '${deltaimport.delta.nid}'" -- Regards, Shalin Shekhar Mangar. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
