index column type="timestamp" in solr from cassandra database -
here using dse-3.0.i want index column type="timestamp" name="datetime" in solr cassandra database.what should fieldtype in schema.xml in solr type="timestamp".please me.i have badly need it. thank database output: -- cqlsh:mykeyspace> select * mysolr ;
key,124 | date_time,2013-02-11 10:10:10+0530 | body,a chicken in every pot ... | date,dec 15, 1933 | name,roosevelt | title,fireside chat
but @ query not gives value of date_time field. query output in solr :-- id,body,title,name,date 124,a chicken in every pot ...,fireside chat,roosevelt,"dec 15, 1933"
what missing configure.please guide me proper way. thank you.
in versions of solr prior 4.2 there timestamp
field in example schema.xml implemented predefined date
fieldtype
<field name="timestamp" type="date" indexed="true" stored="true" default="now" multivalued="false"/>
here date fieldtype definition
<!-- format date field of form 1995-12-31t23:59:59z, , more restricted form of canonical representation of datetime http://www.w3.org/tr/xmlschema-2/#datetime trailing "z" designates utc time , mandatory. optional fractional seconds allowed: 1995-12-31t23:59:59.999z other components mandatory. expressions can used denote calculations should performed relative "now" determine value, ie... now/hour ... round start of current hour now-1day ... 1 day prior now/day+6months+3days ... 6 months , 3 days in future start of current day consult datefield javadocs more information. note: faster range queries, consider tdate type --> <fieldtype name="date" class="solr.triedatefield" precisionstep="0" positionincrementgap="0"/>
so based on example, recommend using date field type, noting stored in utc format.