Invalid timestamp

2014-06-20 Thread sindhu hosamane
Hello,
 i am  dealing with timestamp in my cascalog query .
My code snippet looks like 

   (def datefrom 2010:05:03 13:20:47)

(def custom-formatter (f/formatter :MM:dd HH:mm:ss))

   (def start-value (ct/to-long (f/parse custom-formatter datefrom)))


   (def dateto 2012:09:01 08:17:00)

   (def end-value (ct/to-long (f/parse custom-formatter dateto)))

   

  (defn convert-to-long [a]

   (ct/to-long (f/parse custom-formatter a)))


(?- (stdout) [?timestamp  ?category_description ]

 (info-tap : ?timestamp  ?category_description )

 (convert-to-long ?timestamp : ?converted-timestamp)

  (= ?converted-timestamp start-value)(= ?converted-timestamp 
end-value)

 ) 


my data looks like 

Timestamp;assembly;category_description;eventtext;downtime;tag;process;state

2012:09:01 10:20:00;Turbine1;Event from the CU which indicates an A 
event;Event642;;5;f;5373

2012:09:01 10:20:30;Turbine1;Event from the CU which indicates an A 
event;Event642;;5;f;5373

2012:09:01 10:21:00;Turbine1;Event from the CU which indicates an A 
event;Event642;;5;f;5373

2012:09:01 10:21:30;Turbine1;Event from the CU which indicates an A 
event;Event642;;5;f;5373


I have created a custom formatter same as how my timestamp field  in data 
looks like .But inspite when i run it shows me Caused by: 
java.lang.IllegalArgumentException: Invalid format: Timestamp

whats wrong in my code ? i don't understand.

-- 
You received this message because you are subscribed to the Google
Groups Clojure group.
To post to this group, send email to clojure@googlegroups.com
Note that posts from new members are moderated - please be patient with your 
first post.
To unsubscribe from this group, send email to
clojure+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
Clojure group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to clojure+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: Invalid timestamp

2014-06-20 Thread Mike Fikes
It it perhaps reading the first line of your file and running it trough the 
parser?

-- 
You received this message because you are subscribed to the Google
Groups Clojure group.
To post to this group, send email to clojure@googlegroups.com
Note that posts from new members are moderated - please be patient with your 
first post.
To unsubscribe from this group, send email to
clojure+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
Clojure group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to clojure+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: Invalid timestamp

2014-06-20 Thread Sam Ritchie
yup, responded as such on the Cascalog list. (That's a better place for 
these questions; no need to cross post to the main group.)



Mike Fikes mailto:mikefi...@me.com
June 20, 2014 at 5:57 PM
It it perhaps reading the first line of your file and running it 
trough the parser?

--
You received this message because you are subscribed to the Google
Groups Clojure group.
To post to this group, send email to clojure@googlegroups.com
Note that posts from new members are moderated - please be patient 
with your first post.

To unsubscribe from this group, send email to
clojure+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
---
You received this message because you are subscribed to the Google 
Groups Clojure group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to clojure+unsubscr...@googlegroups.com 
mailto:clojure+unsubscr...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.
sindhu hosamane mailto:sindh...@gmail.com
June 20, 2014 at 3:40 PM
Hello,
 i am  dealing with timestamp in my cascalog query .
My code snippet looks like

(def datefrom 2010:05:03 13:20:47)

(defcustom-formatter(f/formatter:MM:dd HH:mm:ss))

(def start-value (ct/to-long (f/parse custom-formatter datefrom)))


(def dateto 2012:09:01 08:17:00)

(def end-value (ct/to-long (f/parse custom-formatter dateto)))

  (defn convert-to-long [a]

(ct/to-long (f/parse custom-formatter a)))


(?- (stdout) [?timestamp  ?category_description ]

(info-tap : ?timestamp  ?category_description )

(convert-to-long ?timestamp : ?converted-timestamp)

(= ?converted-timestamp start-value)(= ?converted-timestamp end-value)

)


my data looks like

Timestamp;assembly;category_description;eventtext;downtime;tag;process;state

2012:09:01 10:20:00;Turbine1;Event from the CU which indicates an A 
event;Event642;;5;f;5373


2012:09:01 10:20:30;Turbine1;Event from the CU which indicates an A 
event;Event642;;5;f;5373


2012:09:01 10:21:00;Turbine1;Event from the CU which indicates an A 
event;Event642;;5;f;5373


2012:09:01 10:21:30;Turbine1;Event from the CU which indicates an A 
event;Event642;;5;f;5373



I have created a custom formatter same as how my timestamp field  in 
data looks like .But inspite when i run it shows me Caused by: 
java.lang.IllegalArgumentException: Invalid format: Timestamp


whats wrong in my code ? i don't understand.

--
You received this message because you are subscribed to the Google
Groups Clojure group.
To post to this group, send email to clojure@googlegroups.com
Note that posts from new members are moderated - please be patient 
with your first post.

To unsubscribe from this group, send email to
clojure+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
---
You received this message because you are subscribed to the Google 
Groups Clojure group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to clojure+unsubscr...@googlegroups.com 
mailto:clojure+unsubscr...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.


--
Sam Ritchie (@sritchie)
Paddleguru Co-Founder
703.863.8561
www.paddleguru.com http://www.paddleguru.com/
Twitter http://twitter.com/paddleguru// Facebook 
http://facebook.com/paddleguru


--
You received this message because you are subscribed to the Google
Groups Clojure group.
To post to this group, send email to clojure@googlegroups.com
Note that posts from new members are moderated - please be patient with your 
first post.
To unsubscribe from this group, send email to
clojure+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
--- 
You received this message because you are subscribed to the Google Groups Clojure group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to clojure+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.